New to OLAP creation, need help with values order

[gregorhi]

Hi, I've created my first cubes for a work project and while they are working fine, I still can't figure out some fine tuning.

I have a field called "Days Old" in my database (integer) and even though the attribute in the cube file shows system.int32 as datatype, the values are being sorted alphabetically, i.e. 1, 10, 100, 101... when accessing the cube via Excel.

How can I change the order to show listed in numeric order in Excel?

 

[MDXer]

Set them to order by KEY if the Key is in the proper order.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck