Multiple, filter-member selections impact Retrieve Only Top/Bottom.
Multiple filter-axis members are aggregated before they are to sent queries. Because client-based aggregation does not exist in data source servers, queries are processed using server data values. The discrepancy between client aggregations and server-based sorting and ranking results in irregular result sets.
Note: | Users are strongly advised to use one member per dimension in filters when using Retrieve Only Top/Bottom and Restrict Data. |
Table 32. Retrieve Only Top/Bottom Dialog Box
Control | Description |
|---|---|
Select Column | Specifies the columns to which the Retrieve Only Top/Bottom definition is to be applied |
Show | Limits the result set to the specified criteria |
Top | Selects the highest data value, as indicated by the number in the relevant box |
Bottom | Selects lowest data value, as indicated by the number in the relevant 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 |