Show TOC

FilterLocate this document in the navigation structure

A filter is an object that describes a multidimensional extract of data from a data set.

You can use filters in reporting, analysis and planning, to restrict data to a certain business area, certain product groups, or certain time periods for example. By segmenting the data set, you can ensure that users or user groups only have access to the data that is relevant to them and can only see the relevant data areas in an application scenario.

The filter selection applies to the entire query. All the InfoProvider data is aggregated using the filter selection of the query. You can select characteristics from the InfoProvider's directory tree and restrict them to individual characteristic values. You can also select individual characteristic values or exactly one key figure.

Decide whether to base all the query data on the numerical values of just one key figure or to base it on multiple key figures. If you want to base the query on the numerical values of exactly one key figure, select the key figure in question as your filter. You can also use a restricted or calculated key figure for this.

By selecting default values, you can create a query that is based on extensive data, but for which only a specific part of the data is displayed when the query is executed. The data displayed here is the data that you are most interested in. You can then change the filter by adding new objects for example, and analyze the other data.


Example: You want to analyze all customers in a query. In the query's start state however, you initally only want to see special customers.