Hello,
I have 2 measure groups; say X and Y. X is related to the dimensions products and customers, while Y is related to Products only. I needed to create a view combining measures from X and Y. Now if I drag a measure from Y in front of the Customers dimension members the total for that measure is displayed in front of every Customer there. What I really need is to set the measures from group Y to Null when displayed in front of individual customers, and display their total value only on the Customers.All level and for 'Grand Totals'. I tried created a calculated member over that measure to act as a filter by using IIF function to check if customers.currentmember.level.ordinal > 0 to set the calculated measure to Null, else display the underlying value. Things work fine now in the BIDS Browser, but when I try to create the same view in ProClarity the Grand Total is Null. Any Clues?
How about setting IgnoreUnrelatedDimensions to false for Measure Group Y?
http://msdn2.microsoft.com/en-us/library/ms365411.aspx
>>
SQL Server 2005 Books Online
Configuring Measure Group Properties
Measures groups have properties that enable you to define how measure groups function.
...
IgnoreUnrelatedDimensions
Determines whether unrelated dimensions are forced to their top level when members of dimensions that are unrelated to the measure group are included in a query. Default setting is True.
>>
No comments:
Post a Comment