Time dimension error | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Time dimension error

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.

]]>

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |