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