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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
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
Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

 
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
All Courses

From novice to tech pro — start learning today.