Sample 16: Sorting by Top or Bottom Data Values

The following two reports demonstrate the use of TOP and BOTTOM conditional retrieval commands in a report script. For a discussion of various issues related to use of the TOP and BOTTOM commands, see "Restricting and Ordering Data Values" in the Designing and Maintaining Essbase Cubes.