OUTALTMBR

The Essbase Report Writer OUTALTMBR command sets the output alias to the alias name (as defined in the current alias table in the outline) followed by the member name.

Syntax

<OUTALTMBR

Notes

  • Separate the alias and member name with a single space.

  • To produce reports that display the alternate name for a member, you must also use the { OUTALTNAMES } command. If no alternate name exists, only the member name is displayed.

  • OUTALTMBR cannot be used on duplicate member outlines. See REPALIASMBR.

Example

The following example is based on Sample Basic.

<PAGE (Product, Measures)
<COLUMN (Scenario, Year)
{OUTALTNAMES}
<OUTALTMBR
Actual
<CHILDREN Qtr1
<ROW (Market)
<IDESCENDANTS "300"
     !

The report script example above produces the following report:

                   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