[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 475
  • Last Modified:

MDX Query Order by Date

How would i update this MDX to order by a field -- YearMonth

WITH MEMBER [Measures].[ParameterCaption] AS [Sales Period].[Sales Period Name].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Sales Period].[Sales Period Name].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Sales Period].[Sales Period Name].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Sales Period].[Sales Period Name].ALLMEMBERS ON ROWS FROM [MasterCube]
0
vbnetcoder
Asked:
vbnetcoder
  • 2
1 Solution
 
Ryan McCauleyCommented:
The value you're ordering would have to be somewhere in the query (I assume it's part of the "Sales Period" dimension you're working with), and the you'd use the ORDER() function.

http://msdn.microsoft.com/en-us/library/ms145587.aspx
0
 
vbnetcoderAuthor Commented:
It's not in the query and i am not sure how to add it ... that is a part of my problem...
0
 
vbnetcoderAuthor Commented:
ty
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now