You can filter data in a cube view that contains a single row dimension and one or more column dimensions.
When you have two or more dimensions along the columns, you can filter only from the innermost dimension, that is the dimension closest to the view grid.
Procedure
-
Click the column element that contains the values that you want to filter.
-
Select a filter.
- Pre-defined filter - Top 10, Bottom 10, Top 10 Percent, Bottom 10 Percent. The filter is immediately applied to the view.
- Advanced - You can define a custom filter by setting filter parameters in the Filter dialog box, as described in the following steps.
-
Select a Filter type.
| Filter Type
|
Description
|
| TopCount
|
Filters the view to display only the largest n elements, where n is a number specified in the Value option.
|
| BottomCount
|
Filters the view to display only the smallest n elements, where n is a number specified in the Value option.
|
| TopSum
|
Filters the view to display only the largest elements whose sum is greater than or equal to n, where n is a number specified in the Value option.
|
| BottomSum
|
Filters the view to display only the smallest elements whose sum is greater than or equal to n, where n is a number specified in the Value option.
|
| TopPercent
|
Filters the view to display only the largest elements whose sum is greater than or equal to n, where n is a percentage of the dimension total specified in the Value option.
|
| BottomPercent
|
Filters the view to display only the smallest elements whose sum is greater than or equal to n, where n is a percentage of the dimension total specified in the Value option.
|
-
Enter a numeric value in the Value box.
-
Select a Sort order to display the dimension elements in the Cube Viewer in ascending or descending order.
-
Click OK.
Results
A small funnel icon displays next to the column element for which you created a filter.Note: To remove a filter, click the column element for which you created the filter, and click Remove Filter.