The Retrieve Only Top/Bottom Analysis Tool leverages Essbase sorting and ranking to control the size and order of an OLAP query result set. This protects the network server from transmitting, and the client from processing, large result sets.
See Retrieve Only Top/Bottom.