REPMBRALIAS
The Essbase Report Writer REPMBRALIAS command displays member names followed by aliases for members of the dimension specified.
The member name and alias are separated by a single space. 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
<REPMBRALIAS dimensionname
Notes
-
Use
<REPMBRALIAS ""
to display member names followed by aliases for members of all dimensions. -
REPMBRALIAS can be used on unique member outlines or duplicate member outlines.
-
Some formatting commands (for example, RENAME) do not work with REPMBRALIAS.
-
REPMBRALIAS cannot be used in combination with the existing commands OUTMBRALT, OUTALTMBR, OUTALT, OUTALTNAMES, OR OUTMBRNAMES.
Example
The following example is based on Sample Basic.
<PAGE (Product, Measures)
<COLUMN (Scenario, Year)
<REPMBRALIAS Product
Actual
<CHILDREN Qtr1
<ROW (Market)
<IDESCENDANTS "300"
!
This example produces the following report:
300-10 Dark Cream Measures Actual
Jan Feb Mar
======== ======== ========
Market 800 864 880
300-20 Vanilla Cream Measures Actual
Jan Feb Mar
======== ======== ========
Market 220 231 239
300-30 Diet Cream Measures Actual
Jan Feb Mar
======== ======== ========
Market 897 902 896
300 Cream Soda Measures Actual
Jan Feb Mar
======== ======== ========
Market 1,917 1,997 2,015