OUTMBRALT
The OUTMBRALT Report Writer command for Essbase sets the output name as the member name followed by the alias, as defined in the current alias table. The member name and alias are separated by a single space.
Syntax
<OUTMBRALT
Notes
-
OUTMBRALT cannot be used on duplicate member outlines. See REPMBRALIAS.
-
You must precede the OUTMBRALT command with OUTALTNAMES to display the alias, followed by the member name (rather than the member name alone).
-
OUTMBRALT cannot be used on duplicate member name outlines.
-
REPMBRALIAS can be used on both unique and duplicate member name outlines. REPMBRALIAS supercedes OUTMBRALT.
Example
The following example is based on Sample Basic.
<PAGE (Product, Measures)
<COLUMN (Scenario, Year)
{OUTALTNAMES}
<OUTMBRALT
Actual
<CHILDREN Qtr1
<ROW (Market)
<IDESCENDANTS "300"
!
The above report script example produces the following report:
300-10 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