Sorting a dimension in numeric order 1

[Danster]

I have a pivot table based on a SQL Server OLAP cube. One of my dimensions is called 'Month'. Excel is displaying the values within the Month dimension as 1,10,11,12,2,3,4,5,6,7,8,9. I need it in numeric order i.e. 1,2,3,4,5,6,7,8,9,10,11,12 or actual month values such as Jan, Feb, Mar etc.

I've looked both in Excel and Analysis Manager (editing the cube) but for all my scouring & hunting, I cannot get this thing to sort right. Sounds so simple but I reckon I've spent 6 or 7 hours on this little problem with no luck. Surely there's a solution somewhere....

I did have an answer to this same post in the Microsoft Office forum which suggested my source data should already be dates and then I can format in Excel. This wont work for me coz my source data is not dates.

cheers

Danster

 

[MDXer]

In the dimension editor there is a property for Levels called OrderBy your default choices are Key or Name, if you use member properties you can orderby any properties you have added. For example I ad a date property to my Time elements and order by Date just incase the key values aren't in the proper order.

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck

 

[Danster]

Thx MDXer,
One thing I've just discovered - there's another level to editing the dimension, and I found the OrderBy property. Changed it to Key and bingo!!
Boy - must've spent 6 or seven hours trying to work that out...so simple!

 

[MDXer]

Glad you got it working.

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck