Scenario: You have a small Dimension containing a Hierarchy. You need all the child members as well as the parent members to be sorted.

Solution excerpt: Add the Sort Attribute by which the Parent Attribute should be ordered by as a new Attribute Relationship to the Dimension and then set the OrderBy property to Attribute Key and the OrderByAttribute to the Sort Attribute

Example

• Parent Attribute: “PuL”
• Child Attribute: “BwaZeileKey“
• Child Sort Attribute: “Sortierung“
• Parent Sort Attribute: “PulSortierung“

Result