I am trying to order the attributes within a dimension in SSAS 2008.
For Example:
Dimension Name - Product
Attributes - Product Class, Product Group, Product Type
The default alphanumeric ordering of the attributes displayed in an Excel pivot table are as follows
- Product Class
- Product Group
- Product Type
However, I would like to define the order so it displays in the Pivot Tables as follows:
- Product Type
- Product Class
- Product Group
I understand how to order the values within an attribute but actually ordering the attributes has been a little harder. Without prefixing a number in front of the name I am not sure how to do it. Does anyone have any thoughts or experience with this issue. Thanks