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
add comment

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.