OUTALTNAMES
Displays alias names for members in a report.
May be used in conjunction with OUTMBRNAME to switch between member names and alias names in report rows.
The member name, not the alias name, is the default for reporting.
Syntax
{ OUTALTNAMES }
Notes
-
OUTALTNAMES cannot be used on duplicate member outlines. See REPALIAS.
-
OUTALTNAMES is a setting command.
-
The OUTALTMBR or OUTMBRALT commands may be used to redefine the alternate names definition.
Example
The following example is based on Sample Basic.
{WIDTH 15}
//{OUTALTNAMES} If used (commented out), displays alias names for column headers
<PAGE (Measures)
Sales
<COL (Year, Market, Scenario)
Jan Feb Mar
East Actual
<ROW(Measures)
{OUTALTNAMES}
// These members display with aliases.
<IDESCENDANTS "100"
{OUTMBRNAMES}
// These members display their member names as defined in the outline.
<IDESCENDANTS "200"
{OUTALTNAMES}
// Switches back to alias names, as defined in the current alias table.
<IDESCENDANTS "400"
!
This example produces the following report:
Sales East Actual
Jan Feb Mar
============== ============== ==============
Cola 1,812 1,754 1,805
Diet Cola 200 206 214
Caffeine Free Cola 93 101 107
Colas 2,105 2,061 2,126
200-10 647 668 672
200-20 310 310 312
200-30 #Missing #Missing #Missing
200-40 896 988 923
200 1,853 1,966 1,907
Grape 562 560 560
Orange 219 243 213
Strawberry 432 469 477
Fruit Soda 1,213 1,272 1,250