Multiple filter dimension member selections impact Retrieve Only Top/Bottom.
Multiple filter axis dimension members are aggregated before being sent in a query. Because the client-based aggregation does not exist in the data source server, the query is processed in terms of the data values on the server. The discrepancy between client aggregations and server-based sorting and ranking results in irregular result sets.
Nominate only single filter dimension member selections when using Retrieve Only Top/Bottom and Restrict Data analysis tools.
Control | Description |
|---|---|
Select Column | Specifies the columns to which the Retrieve Only Top/Bottom definition is applied. |
Show | Limits the result set to these criteria: |
Top | Selects the number of highest data values indicated by the corresponding value text box. |
Bottom | Selects the number of lowest data values indicated by the corresponding value text box. |
Sorting | |
Ascending | Displays the result set in ascending alphanumeric order. |
Descending | Displays the result set in descending alphanumeric order. |
Clear | Deletes all Retrieve Only Top/Bottom definitions. |