Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sorting in DMX Query... Expand / Collapse
Author
Message
Posted Wednesday, September 5, 2012 1:50 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, December 23, 2014 7:08 AM
Points: 56, Visits: 258
Hi All,
I am using order function in a MDX query to get the member values of a dimension in Alphabetical order - A to Z. This dimension member is one of the parameter of my report.

But there is a challenge. I have data like
Abraham Lincoln 
Afzal Khan
All

So now as it is working in Ascending order format. Data is show like this in the Drop down list box.

I want to achieve the order like this, irrespective of the names. The All values has to be displayed first in the drop down menu of parameter.

All
Abraham Lincoln
Afzal Khan

Please suggest any suitable MDX based solution ?

Thanks in advance.
Post #1354365
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse