order by in a parameter

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply