DIMBOTTOM
Adds all level 0 dimension members to the report.
Syntax
<DIMBOTTOM mbrNameNotes
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,857Related Topics