Date parameter - order by date reverse

I have a drop down parameter by date --- is there any way to make the list go in reverse order by date?
vbnetcoderAsked:
Who is Participating?
 
Simone BConnect With a Mentor Senior E-Commerce AnalystCommented:
Each parameter should have its own data set. If you select your date parameter in the Dataset dropdown (in Data view), you should be able to add an ORDER BY clause as shown in the image.

Image
0
 
vbnetcoderAuthor Commented:
What I am doing is a little different because I am using SSAS cubes ... but I should be able to do that in the MDX. I will try
0
 
Simone BSenior E-Commerce AnalystCommented:
Yes, it will be the same thing. You need to specify the order in your parameter dataset. Sorry, I'm not an MDX-pert. The code is different, but the theory is the same. I'll poke around and see if I can find any examples.
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
ValentinoVBI ConsultantCommented:
Ordering in MDX is not really comparable to T-SQL.  But it can be done nevertheless!  What you need to use is the ORDER() function.

Hace a look at the following article for some more examples besides the ones on MSDN: Ordering a Dimension Hierarchy in MDX
0
 
vbnetcoderAuthor Commented:
Having trouble getting this to work (I know nothing about MDX :():

This is my MDX ..... how would i order by YearAndMonth (not currently a field in this query).

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
 
vbnetcoderAuthor Commented:
This put me on the right track .... thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.