You can arrange members in the outline tree in alphanumerical order (0 to 9, A to Z) or reverse alphabetical order (Z to A, 9 to 0).
You cannot use sort commands to rearrange level 0 members of attribute dimensions.
To sort all members in the level below a dimension or member:
Open the outline in edit mode.
The Outline tab is displayed.
Right-click the dimension or member whose members you want to sort.
If you want to sort the members in alphanumerical order, select Sort children ascending.
If you want to sort the members in reverse alphanumerical order, select Sort children descending.
Caution! | Sorting members can place a shared member before its actual member in the outline. Placing a shared member before its actual member is not recommended. |
“Positioning Dimensions and Members” in the Oracle Essbase Database Administrator's Guide