Time dimension error | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
Time dimension errorHello
I have SSAS 2005 cube. The dimension has hierarchy Year> Quarter>
When data is browsed in Quarter it shows month in haphazard manner Like
While it should show me
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.
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.