Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: Order in MDX

    I did this is way...

    But can to order per month...

    WITH

    MEMBER [Measures].[ParameterCaption] AS '[Data].CURRENTMEMBER.MEMBER_CAPTION'

    MEMBER [Measures].[ParameterValue] AS '[Data].CURRENTMEMBER.UNIQUENAME'

    MEMBER [Measures].[ParameterLevel] AS '[Data].CURRENTMEMBER.LEVEL.ORDINAL'

    SELECT {

    [Measures].[ParameterCaption],

    [Measures].[ParameterValue],

    [Measures].[ParameterLevel]

    } ON 0,

    ORDER(

    (

    [Data].ALLMEMBERS

    ),

    [Measures].[ParameterCaption],

    DESC

    )

    ON 1

    FROM [DMOB700]

    Sample...

    DD/MM/YYYY

    24/02/2009

    23/02/2009

    22/02/2009

    21/02/2009

    20/02/2009

    19/02/2009

    18/02/2009

    24/03/2009

    23/03/2009

    22/03/2009

    21/03/2009

    20/03/2009

    19/03/2009

    18/03/2009

Viewing post 1 (of 2 total)