Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a dimension with a Parent Child hierarchy. This hierarchy is ordered according to an attribute of the dimension. Is there some way to create a calculated member that uses the Sort Order attribute? I would like to be able to sort members of my parent child dimension based on another attribute.

In my relational Dimension Table I have the following columns (among others)

Dim1_Key Dim1_ParentKey Dim1_MemberName Dim1_SortSequence

I have managed to construct the parent child dimension and would like to use the Dim1_SortSequence attribute to sort members, however when I try and set up a new attribute relationship, I receive the following message:

"a parent attribute can't have attribute relationships"

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.