REPALIASMBR
The Essbase Report Writer REPALIASMBR command displays alias names followed by member names for members of the dimension specified in the report output.
The alias and member name 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
<REPALIASMBR dimensionname
Notes
-
Use
<REPALIASMBR ""
to display alias names followed by member names for members of all dimensions. -
REPALIASMBR can be used on unique member outlines or duplicate member outlines.
-
Some formatting commands (for example, RENAME) do not work with REPALIASMBR.
-
REPALIASMBR 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)
<REPALIASMBR Product
Actual
<CHILDREN Qtr1
<ROW (Market)
<IDESCENDANTS "300"
!
This example produces the following report:
Dark Cream 300-10 Measures Actual
Jan Feb Mar
======== ======== ========
Market 800 864 880
Vanilla Cream 300-20 Measures Actual
Jan Feb Mar
======== ======== ========
Market 220 231 239
Diet Cream 300-30 Measures Actual
Jan Feb Mar
======== ======== ========
Market 897 902 896
Cream Soda 300 Measures Actual
Jan Feb Mar
======== ======== ========
Market 1,917 1,997 2,015