Sorting the Dimension Hierarchy

After creating the hierarchy, or after importing dimensions and members, you may want to sort the hierarchy.

When you select the member, it is sorted based on its current sort in the hierarchy, which is numeric or alphabetic.

You can sort members individually, or sort all the descendants for a specific member. Note that if you select a parent, all its descendants will be sorted with the parent member.

You cannot revert or cancel a change to the hierarchy. If you want to revert to a previous order, you must resort the members.

To sort members:

1. On the Dimension Overview, select the Hierarchy tab .
2. Highlight the member or parent for which you want to sort the children or descendants.
3. From Actions, select the required sort:

   • Sort Ascending, then Children or Descendants

   • Sort Descending, then Children or Descendants

   Note:

   If you select Children, only the direct children of the selected member are sorted. If you select Descendants, all members below the selected member will be sorted.

4. Click Close.
5. Select Actions, then Deploy, and then the model name to update the model.