Sorting a Time Dimension – This should be easy | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Sorting a Time Dimension – This should be easy


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?
]]>