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
hpsuserAsked:
Who is Participating?
 
ValentinoVConnect With a Mentor BI ConsultantCommented:
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 :) )
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.