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"