We help IT Professionals succeed at work.

How to use the attribute key value as the sort order in a SSAS cube

Hello,

I have a SSAS cube with a dimension "PRODUCT DIMENSION".  Within this dimension, I would like the "PRODUCT" attribute to always sort according to the "PRODUCT KEY" attribute.

Is there a way to do this?

Thanks
Comment
Watch Question

BI Consultant
SILVER EXPERT
Most Valuable Expert 2011
Commented:
Select the Product attribute and change the OrderBy property to "Key".

(This assumes that your "PRODUCT KEY" attribute is the dimension key.  If it's not, you should really consider renaming it :) )

Explore More ContentExplore courses, solutions, and other research materials related to this topic.