DIMTOP
The Essbase Report Writer DIMTOP command adds the top of the dimension for the member to the report.
Syntax
<DIMTOP mbrName
Notes
You can specify any member from the dimension, including the top member.
Example
<DIMTOP Stereo
Adds the top of the Product dimension to the report.
<PAGE (Market, Accounts, Scenario)
Chicago Sales Actual
<COLUMN (Year)
<ICHILDREN Year
<ROW (Product)
<DIMTOP Stereo
!
This example produces the following report:
Chicago Sales Actual
Qtr1 Qtr2 Qtr3 Qtr4 Year
======= ======= ======= ======= =======
Product 16,536 15,599 17,411 21,374 70,920