SQL Server Performance

Wrong sorting order of Date dimension in Excel.

Discussion in 'SQL Server 2005 Analysis Services' started by victorv, Jun 22, 2011.

  1. victorv New Member

    I have a Date/Calendar dimension in my cube. When I open my cube in SSAS cube browser, and then expend year to quarter and then quarter to month, those months labels show in correct order, Jan, Feb, Mar and so on. But when I do the same in Excel 2007, when I am connected to the same cube, the order of those months is alphabetical. I tried to change different sorting options, like "Data source order", "Ascending by Month", "Autosort" and so on, nothing works. It's like Excel completely ignores it's own settings and only sorts alphabetically.
    Is there a way to make it work ?
    Please, help. It's an urgent project.

    Thank you,
  2. satya Moderator

    Do you have any CUBESET formula based in Excel 2007 sheet?
    What is the service pack level on Office tools?

Share This Page