Syntax

<DIMBOTTOM mbrName

Parameters

mbrName

A member from the dimension.

Notes

This command adds all level 0 members to the report. mbrName is from the dimension whose level 0 members you want to select. Regardless of the member you specify, Essbase retrieves all level 0 members of that dimension. For example, if you specify Audio in the Demo Basic database, Essbase retrieves all the level 0 members under Audio and under Visual, because they are all level 0 members of the Product dimension.

Example

The command <DIMBOTTOM Audio adds all the members from the bottom of the Product dimension:

<PAGE (Market, Accounts, Scenario)
Chicago Sales Actual
      <COLUMN (Year)
      <ICHILDREN Year
<ROW (Product)
<DIMBOTTOM Audio
     !
         

This example produces the following report:

                        Chicago Sales Actual 
                 Qtr1    Qtr2    Qtr3    Qtr4     Year
              =======  ======  ======  ======  =======
Stereo          2,591   2,476   2,567   3,035   10,669
Compact_Disc    3,150   3,021   3,032   3,974   13,177
Television      4,410   4,001   4,934   6,261   19,606
VCR             3,879   3,579   4,276   4,877   16,611
Camera          2,506   2,522   2,602   3,227   10,857