Sample 16-A: Bottom Data Values
The following Essbase report script sample demonstrates the basic use of the BOTTOM command.
This sample report is based on the Sample Basic database.
Measures
Actual Budget
Jan Dec Jan Dec
======== ======== ======== ========
East 200 158 233 280 340
300 184 277 240 210
Diet 181 213 200 240
West 100 378 223 830 530
300 755 971 830 950
400 454 434 470 370
South 200 480 496 520 390
Diet 355 404 490 430
300 188 213 270 240
Central 300 790 824 930 810
100 724 792 900 890
400 691 785 660 650
Market 200 2,141 2,302 2,710 2,810
300 1,917 2,285 2,270 2,210
400 1,611 1,720 1,730 1,600
Use the following script to create Sample 16-A:
<Sym
<Column (Scenario, Year)
Actual Budget
Jan Dec
<Row (Market, Product)
<ICHILDREN Market
<ICHILDREN Product
<Bottom (3, @DataColumn(3))
!
The BOTTOM command specifies that only the three lowest data values are returned for each row grouping, based on the target data values specified in column three (Budget, Jan). Notice that no row dimension is selected here, so the report output defaults to the innermost row.