SQL Server Performance

Time dimension error

Discussion in 'SQL Server 2005 Analysis Services' started by KVS, Jun 11, 2009.

  1. KVS New Member

    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
  2. Sandy New Member

    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.
  3. KVS New Member

    I have tried setting the dimension property called Order by .. but no help..
    Can you pls help me setting the correct order.
  4. Sandy New Member

    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.

Share This Page