Adds all level-0 dimension members to the report, if the dimension is not Hybrid Analysis-enabled. In a Hybrid Analysis-enabled dimension, DIMBOTTOM adds the bottom members in a relational source only.
Syntax
<DIMBOTTOM mbrName
Parameter | Description |
---|---|
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
See Also