Filter

You use filters to specify which values are included in a report. You can exclude or include elements which have a caption, unique name, attribute or values which match criteria that you specify. You can also define filters with MDX statements.

The most common use of a filter is to exclude zero values.

Another use is to find or exclude null values.

Filters can be combined with the operators AND, OR, NOT so that a report shows, for example, values between 'x' and 'y' and not less than 'z'.

You create a value filter in two steps. You specify the values and operators. Then you specify the data to which to apply the filter. In many cases, this is the same as the data displayed in the report. But, you might want to filter a separate range of data: for example, to show only sales outlets in 2004 which reported sales above a certain amount in 2003.