REPALIAS

Displays alias names for members of the dimension specified.

If no alias exists for a member, the member name only is displayed. The current alias table is used unless OUTALTSELECT is used to specify an alternative alias table.

Syntax

<REPALIAS dimensionname

Notes

  • <REPALIAS "" specifies the command for all dimensions.

  • REPALIAS can be used on unique member outlines or duplicate member outlines.

  • Some formatting commands (for example, RENAME) do not work with REPALIAS.

  • REPALIAS cannot be used in combination with the existing commands OUTMBRALT, OUTALTMBR, OUTALT, OUTALTNAMES, OR OUTMBRNAMES.

Example

The following example is based on Sample Basic.

{WIDTH 15}
<PAGE (Measures)
Sales
<COL (Year, Market, Scenario)
Jan Feb Mar
 East Actual
<ROW(Product)
<IDESCENDANTS "100"
<IDESCENDANTS "200"
<IDESCENDANTS "400"
<REPALIAS product
// Displays aliases for all Product members
!

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 
Old Fashioned               647            668            672 
Diet Root Beer              310            310            312 
Sasparilla             #Missing       #Missing       #Missing 
Birch Beer                  896            988            923 
  Root Beer               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