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