Alphabetically sorts members by their alternate names within a member selection command (for example, <CHILDREN).
Syntax
<SORTALTNAMES
Notes
This command sorts alphabetically all members added with a member command (for example, <CHILDREN) by their alternate name. Members entered directly in the report specification without a member command, calculated rows and column names, or member commands encountered in the specification prior to the SORTALTNAMES command, are not affected by the command.
This command must precede the selection commands, for example, CHILDREN or DESCENDANTS. If no sorting commands are used, members are output in hierarchical order based on the member outline. Any sort command remains in effect until another sort command is issued.
Example
The following example is based on Demo Basic.
The command <SORTALTNAMES sorts the members added to the report with the <IDESCENDANTS Product command by the alternate name of each member. The command {OUTALTNAMES} causes alternate member names to be displayed in the report. {NOINDENTGEN} turns off hierarchical indenting so the row names line up. Indented row names are not particularly useful when the output is sorted on any criteria other than generation.
Chicago Sales Actual Qtr1 Qtr2 Qtr3 Qtr4 ======== ======== ======== ======== Audio 5,741 5,497 5,599 7,009 Camera 2,506 2,522 2,602 3,227 Compact_Disc 3,150 3,021 3,032 3,974 Product 16,536 15,599 17,411 21,374 Stereo 2,591 2,476 2,567 3,035 Television 4,410 4,001 4,934 6,261 VCR 3,879 3,579 4,276 4,877 Visual 10,795 10,102 11,812 14,365 Chicago Sales Actual Qtr1 Qtr2 Qtr3 Qtr4 ======= ======= ======= ======= Audio 5,740 5,375 5,509 6,488 CD 3,290 3,034 3,132 3,571 Camera 2,230 2,255 2,266 3,162 Items 15,812 15,050 16,716 19,159 Media 10,072 9,675 11,207 12,671 Radio 2,450 2,341 2,377 2,917 TV 4,197 3,757 4,740 5,000 Video 3,645 3,663 4,201 4,509
See Also