Show TOC

Filtering data Locate this document in the navigation structure

In Analysis, you can define criteria to restrict the data displayed in your analysis to a subset of data. This action is called filtering. By filtering, you define which subset of data appears in the analysis. This allows you to create new, more specific views of your data. Filters are additive, which means that each additional filter is based on the current filter and further reduces the subset of data.

There are two types of filters. With "Filtering members", you can specify which members to display and which not to display in your analysis. You can also define members to use as filters in the background of the analysis. With "Filtering measures", you can specify which measure values should be displayed in the analysis. For example, you can define that you want to see the Top 3 regions in sales volume for each product in your analysis. You can also filter out rows and columns that contain only zeros.