| T O P I C R E V I E W |
| Adrian |
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 |
| 8 L A T E S T R E P L I E S (Newest First) |
| Adrian |
Posted - 09/19/2006 : 14:42:34
This is fixed in build 126.
Cheers |
| admin |
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 |
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 |
Posted - 08/23/2006 : 21:16:53
Please explain how to reproduce the problem with Foodmart 2000 or Adv Works.
|
| Adrian |
Posted - 08/23/2006 : 14:44:25
Yes
I have existing reports that users can no longer adjust the filters on. |
| admin |
Posted - 08/22/2006 : 20:42:20
Is this still an open issue? |
| Adrian |
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 |
Posted - 08/21/2006 : 10:42:05
Do you get an error message? |
Report Portal
