REPALIAS
The Essbase Report Writer REPALIAS command 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
-
Use
<REPALIAS ""
to display alias names for members in all the 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