SORTMBRNAMES

The SORTMBRNAMES command in Essbase Report Writer sorts members added with a member selection command, such as <CHILDREN, alphabetically by member name. Not affected are members entered without using a member selection command, calculated rows and column names, or member commands encountered in the specification prior to the SORTMBRNAMES command.

If used, SORTMBRNAMES must precede the selection commands. Any sort command remains in effect until another sort command is issued.

Syntax

<SORTMBRNAMES

Notes

SORTMBRNAMES disregards hierarchical relationships between members.
Numeric characters rise above alphanumeric characters in the sort order. For example, 100 rises above A200, which rises above Accounts.
If SORTASC or SORTDESC are used to control sorting, they must precede the SORTMBRNAMES command.

Example

The following report script example is based on Sample Basic.

<PAGE (Product, Measures)
Sales
<COLUMN (Scenario, Year)
Actual Budget
Jan Feb Mar
<ROW (Market)
<SORTMBRNAMES
<IDESCENDANTS South
     !

The above example produces the following report:

                                     Product Sales 

                           Actual                     Budget           
                      Jan      Feb      Mar      Jan      Feb      Mar 
                 ======== ======== ======== ======== ======== ======== 
Louisiana             978      980      948      900      910      900 
New Mexico            563      578      600      560      560      590 
Oklahoma              980      980    1,001      920      920      940 
  South             3,976    4,082    4,055    3,870    3,970    3,990 
Texas               1,455    1,544    1,506    1,490    1,580    1,560