Sorting Dimensions and Members

You can have Essbase arrange dimensions within an outline or members within a dimension in alphabetical order (A–Z) or reverse alphabetical order (Z–A). For a list of consequences of sorting dimensions and members, see Moving Dimensions and Members.

When you sort level 0 members of numeric attribute dimensions in outlines, the members are sorted by their values. For example, Figure 37, Sorting Numeric Versus Text Attribute Dimension in Ascending Order shows text and numeric versions of the Sizes attribute dimension after sorting the members in ascending order. The members of the numeric attribute dimension (on the right) are sequenced by the numeric values of the members; the member 8 is before the other members. In the text attribute dimension (on the left), because the characters are sorted left to right, the member 8 is after the member 24.

Figure 37. Sorting Numeric Versus Text Attribute Dimension in Ascending Order

This image shows the ascending order of sorted values. For the text attribute dimension, the member order is 12, 16, 24, 8. For the numeric attribute dimension, the member order is 8, 12, 16, 24.

You cannot sort Boolean attribute dimensions. See Understanding Attribute Types.

  To sort members using Outline Editor, see “Sorting Members” in the Oracle Essbase Administration Services Online Help.