Sorting Members

You can sort members in ascending or descending order, by children or descendants. Sorting members affects the outline.

To sort members:

  1. Click Navigator Navigator icon.

  2. Under Create and Manage, click Dimensions.

  3. Select the dimension for the members.

  4. Under Dimensions, select the members for which you want to sort the children or descendants.

  5. Under Sort, select children or descendants.

    Sorting by children affects only members in the level immediately below the selected member. Sorting by descendants affects all descendants of the selected member.

  6. Click Sort Ascending to sort by ascending order or Sort Descending to sort by descending order.

  7. Click OK.

    The next time you create or refresh the database, the outline is generated with members in the order that is displayed.