Show TOC

To create a background filterLocate this document in the navigation structure

Context

In Analysis, you can set filters for dimensions and hierarchies that you have chosen to be displayed in the crosstab. This allows you to narrow the scope of your analysis to the data you need. You can however also select members for filtering that should not be displayed in the crosstab. These non-visible filters are background filters.

For example, you have selected the dimensions Product and Region to be displayed in the crosstab. The data source contains the sales volume for the years, 2008, 2009 and 2010. If you are only interested in the sales volume for 2010, you can add the Year dimension as a background filter to your analysis and filter for 2010. The analysis will show the data for year 2010, but the Year dimension is not visible in the crosstab.

Note Background filters for a measure dimension can contain only one measure as a filter. The same is true for other dimensions that do not aggregate.

You have the following options to add a background filter to your analysis:

Procedure

  1. You can add a dimension to the Background Filter area and define a filter:
    1. Add the dimension that you want to add to the Background Filter area in the design panel.
      You can add the dimension using drag and drop or you can choose Move to Background Filter in the context menu.
    2. Choose Filter By Member in the context menu.
      The Filter by Member dialog box appears.
    3. Make your selection and press OK.
      The background filter is created.
  2. Or: You can add a dimension that already has a filter. The existing filter will be applied as a background filter in the crosstab.
  3. Or: You can add a background filter using the context menu on the crosstab.
    1. Select the member(s) that you want to define as background filter in the crosstab.
    2. Choose Filter Members and Swap With in the context menu.
      The dimension with the selected filters is added automatically to the Background Filter area, and the dimension chosen for swapping with is added to the Rows area in the design panel.

Results

The data in the crosstab is displayed according to your filter selection.