Server-based sorting is provided by Retrieve Only Top/Bottom and executed on Analytic Server. Server-based sorting is performed by the server prior to returning the OLAP query result set to the client, thus minimizing the result set and network traffic.