I have a problem where Named set works perfectly in the MDX Query Editor but when defined as Dynamic named set in SSAS Cube it doesn't evaluate the Where clause or Filter in cube browser.
I tried using EXISTING to force the current context but to no avail.
Here's the query which works in MDX Query Editor.
WITH SET [NewSet] AS
[Machine].[Machine Serial Number].[Machine Serial Number].Members *
[Machine].[Effective Date].[Effective Date].Members *
[Machine].[Expiration Date].[Expiration Date].Members
,([Machine].[Effective Date].CurrentMember.MemberValue <= [Date].[Business Date].CurrentMember.MemberValue AND
[Machine].[Expiration Date].CurrentMember.MemberValue >= [Date].[Business Date].CurrentMember.MemberValue
[Measures].[Cash Played] ON 0,
[NewSet] ON 1
([Locations].[d Location ID].&,[Date].[Business Date].&[2013-01-01T00:00:00])
Any suggestions in right direction will be really helpful!
So if you create the dynamic 'NewSet', it won't show the relevant members if it on axis (like '[NewSet] ON 1') ?
Try something like : EXISTS([Machine].[Machine Serial Number].[Machine Serial Number].Members,NewSet)
About sets in the where clause, please refer the next link (Maybe the attribute hierarchy is the answe ?) :
Hope it helps :)
Regards, David .
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?