The Retrieve Only Top/Bottom analysis tool leverages Essbase server-based sorting and ranking to control the size and order of an OLAP query result set. This can protect the network server from transmitting, and the client from processing, large result sets. The Retrieve Only Top/Bottom analysis tool is central to top/bottom analysis.
Although you can apply Retrieve Only Top/Bottom to the result set of a processed query (using the Analysis Tools shortcut menu), you can also define Retrieve Only Top/Bottom criteria before submitting a query. Click the Data Layout Options button and select the Retrieve Only Top/Bottom menu item, to define a Retrieve Only Top/Bottom definition before sending a query. The last step of the Document Creation wizard also enables you to create Retrieve Only Top/Bottom definitions.
The Information panel Retrieve Only Top/Bottom segment is displayed all Essbase Retrieve Only Top/Bottom definitions for the current document.