Hello I have SSAS 2005 cube. The dimension has hierarchy Year> Quarter> Month>Day> Hour When data is browsed in Quarter it shows month in haphazard manner Like 2005 2005 Q1 February January March While it should show me 2005 2005 Q1 January February March i.e. they should be sorted in ascending manner. How can I achieve this. SQL Server 2005 SP2
You can try to sort the dimension view or in dimension property you can check for the same. Hope you can get the correct order. Thanks, Sandy.
I have tried setting the dimension property called Order by .. but no help.. Can you pls help me setting the correct order.
If you are getting the Time dimension from view/table then based on a key/identity column get the ordered data. Else, if you have the monthnumber defined in the table you can use that for ordering. Thanks, Sandy.