Wrong sorting order of Date dimension in Excel. | SQL Server Performance Forums
SQL Server Performance Forum – Threads Archive
Wrong sorting order of Date dimension in Excel.Hi.
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,
Do you have any CUBESET formula based in Excel 2007 sheet?
What is the service pack level on Office tools?