order by in a parameter

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » order by in a parameter

order by in a parameter

Rate Topic

Display Mode

Topic Options

Author

Message

ian.dunlop 7059

Posted Monday, May 17, 2010 8:50 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, November 01, 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

Hari.Sharma

Posted Monday, May 24, 2010 12:26 AM

Ten 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 »

Permissions