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.