vbnetcoder
asked on
MDX Query Order by Date
How would i update this MDX to order by a field -- YearMonth
WITH MEMBER [Measures].[ParameterCapti on] AS [Sales Period].[Sales Period Name].CURRENTMEMBER.MEMBER _CAPTION MEMBER [Measures].[ParameterValue ] AS [Sales Period].[Sales Period Name].CURRENTMEMBER.UNIQUE NAME MEMBER [Measures].[ParameterLevel ] AS [Sales Period].[Sales Period Name].CURRENTMEMBER.LEVEL. ORDINAL SELECT {[Measures].[ParameterCapt ion], [Measures].[ParameterValue ], [Measures].[ParameterLevel ]} ON COLUMNS , [Sales Period].[Sales Period Name].ALLMEMBERS ON ROWS FROM [MasterCube]
WITH MEMBER [Measures].[ParameterCapti
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ty
ASKER