Sorts members alphabetically by name.
<SORTMBRNAMES
This command sorts all members added with a member selection command, such as <CHILDREN alphabetically by member name when the members are added to the report. Members entered directly in the report specification without a member selection command, calculated rows and column names, or member commands encountered in the specification prior to the SORTMBRNAMES command, are not affected by the command.
This command must precede the selection commands. Any sort command remains in effect until another sort command is issued.
The following example is based on Sample Basic.
<PAGE (Product, Measures)
Sales
<COLUMN (Scenario, Year)
Actual Budget
Jan Feb Mar
<ROW (Market)
<SORTMBRNAMES
<IDESCENDANTS South
!
This 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
|
| ©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |