SQL Server Performance

Sorting a Time Dimension - This should be easy

Discussion in 'Analysis Services/Data Warehousing' started by boydd_uk, Apr 28, 2005.

  1. boydd_uk New Member


    I have a Time Dimension setup - Year, Quarter, Month. Simple.

    I've set the Order By property in the Dimensions to Key so no problem here.

    If I just put the Dimension on an Axis everything is fine the hierarchy is correct and it's in the correct order.

    Now, I need to reverse this hierarchy ordering for a drop-down in RS so I do the following:

    So I do;

    WITH MEMBER Measures.NullColumn AS 'Null'
    SELECT
    {Measures.NullColumn} ON COLUMNS,
    ORDER( { [Month End].[Month].members },[Month End], DESC) ON ROWS
    FROM
    [MyCube]

    It don't work. What am I doing wrong here? Surely reversing the ordering of my Time Dimension should be easy?

Share This Page