| Author |
 Topic  |
|
|
Adrian
New Zealand
28 Posts |
 Posted - 08/20/2006 : 20:10:40
|
Hi
Since downloading version 119, I've been having a problem with existing reports with calculated measures.
I can no longer create measures as below (by typing in MDX), I can no longer filter existing report that contain these measures (filter drop downs are blank).
member [Measures].[Fees] as 'SUM({[TransTypeSales].[All TransTypeSales].[Other].[Fee]},[Measures].[Amount])', format = 'Standard'
Cheers
Adrian |
|
|
admin
1645 Posts |
Posted - 08/21/2006 : 10:42:05
|
| Do you get an error message? |
 |
|
|
Adrian
New Zealand
28 Posts |
Posted - 08/21/2006 : 19:27:57
|
Hi I don't get an error message, just the drop down box is blank, so I can't do any filtering. If I create a simple measure such as:
Measures].[A] as '[Measures].[Amount]', format = 'Standard', it works fine.
I seem to be able to create the Measures again now- not sure why couldn't before. |
|
|
|
admin
1645 Posts |
Posted - 08/22/2006 : 20:42:20
|
| Is this still an open issue? |
|
|
|
Adrian
New Zealand
28 Posts |
Posted - 08/23/2006 : 14:44:25
|
Yes
I have existing reports that users can no longer adjust the filters on. |
|
|
|
admin
1645 Posts |
Posted - 08/23/2006 : 21:16:53
|
Please explain how to reproduce the problem with Foodmart 2000 or Adv Works.
|
|
|
|
Adrian
New Zealand
28 Posts |
Posted - 08/23/2006 : 21:53:45
|
HI I came up with this query, I created the calc member called [Calc Member]. When I add a filter to this it doesn't work
Cheers
with member [Measures].[Calc Member] as 'SUM({[Education Level].[All Education Level]},[Measures].[Unit Sales])', format = 'Standard'
Select non empty HIERARCHIZE(DISTINCT({{
{[Gender].DefaultMember}}})) on rows,
non empty {
[Measures].[Calc Member]} on columns
From [Sales]
|
|
|
|
admin
1645 Posts |
Posted - 08/24/2006 : 22:07:06
|
Thanks for your calc member formula. However, I still can’t reproduce the problem.
What dimension are you trying to filter by?
What is the error message that you get?
What is the MDX that produces the error? |
|
|
|
Adrian
New Zealand
28 Posts |
Posted - 09/19/2006 : 14:42:34
|
This is fixed in build 126.
Cheers |
|
|
| |
Topic |
|
Report Portal
Problem with using SUM in calculated Measures
