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

order by in a parameter Expand / Collapse
Author
Message
Posted Monday, May 17, 2010 8:50 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, November 1, 2011 6:20 AM
Points: 20, Visits: 170
Hi All, I am new to MDX - I have a customer asking for the data in a dropdown in Reporting services to be sorted Either Asc or Desc.... Syntax below

WITH MEMBER [Measures].[ParameterCaption] AS [Customer].[Customer Name Code].CURRENTMEMBER.MEMBER_CAPTION MEMBER [Measures].[ParameterValue] AS [Customer].[Customer Name Code].CURRENTMEMBER.UNIQUENAME MEMBER [Measures].[ParameterLevel] AS [Customer].[Customer Name Code].CURRENTMEMBER.LEVEL.ORDINAL SELECT {[Measures].[ParameterCaption], [Measures].[ParameterValue], [Measures].[ParameterLevel]} ON COLUMNS , [Customer].[Customer Name Code].ALLMEMBERS ON ROWS FROM ( SELECT ( STRTOSET(@CustomerRepName, CONSTRAINED) ) ON COLUMNS FROM [MY CUBE])

I have tried and better tried - but contiunue getting errors which I think (hope) is lack of knowledge is how to wrap the customer name that is being filtered using ORDER to Asc so that the dropdown that it is filtering data for will appear in a Either Asc order


Any ideas
Post #922946
Posted Monday, May 24, 2010 12:26 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, December 26, 2012 12:43 PM
Points: 1,330, Visits: 455
Try this link:

Sort Dimension Members in DESCending order


Cheers,
Hari
Tips & Tricks for SQL BI Developers
Post #926628
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse