Filtering by Member via the Toolbar

  1. Select the header of the dimension to filter in the cross tab
  2. In the Analysis ribbon toolbar, select the "Filter"
  3. Select "Filter by Member..."
  4. Make the selection and click OK

 

 

Filtering by Member from the crosstab

  1. Select the value of the member you want to filter.
  2. Drag and drop the value :
  • On the the Dimension Header or in the Design Panel Row or Column to Filter on this Value
  • Out of the cross tab or in Design Panel datasource fields to Exclude this value from filter 

Filter data by Member via right click

From the Crosstab :

  1. Right click to a Dimension
  2. Select « Filter By Member »  

From the design panel :

Filter data via Background Filter

Background Filter allows filtering on the Dimension that is not in the Crosstab  

  1. In the Design Panel select a Dimension, Right click and select « ADD to Filter »
  2. Make your selection and press OK 

Filtering on attributes 25 SP 2.01 Version 

Filtering Individual selections or range selections

You can filter via Individual selections. In this case you can select/unselect individually each value :

You can select via "Range Selection". In this case you can use multiple filters :

 

 

Removing a Filter

Solution 1: Select the dimension header, right click and Select All Members

 

Solution 2: In the Analysis Tab, select the dimension, right click and Select All Members.

 

Filter by Measure

  1. Select the Dimension.
  2. Click the « Filter » button and select « Filter by Measure ».
  3. Select the measure, set your filter, you can Add multiple filter, then press OK  .

If you choose a Dimension instead of a measure before filtering by measure, the filter is applied directly on the level of the selected dimension

 

The following options define on witch level the filter is applied :

  • All Dimensions Independantly

If you select this option, the filter is applied to all dimensions in the analysis, from the outermost to the most detailed one. For example, in an analysis with three dimensions in columns A, B and C, the filter is first applied to the dimension in column A, then to the dimension in column B and finally to the dimension in column C.

 

  • Most Detailed Dimension in Rows
If you select this option, the filter is applied to the most detailed dimension of the rows. For example, in an analysis with three dimensions in columns A, B and C, the filter is applied to the dimension in column C. This option is optimized for threshold value filtering.
  • Most Detailed Dimension in Columns
If you select this option, the filter is applied to the most detailed dimension of the columns. For example, in an analysis with three dimensions in rows 2, 3and 4, the filter is applied to the dimension in row 4. As with the option above, this option is also recommended for threshold value filtering. 

Remove a filter by Measure

Solution 1: Select the dimension, right click and Select Filter by Measure, select « Reset »

Solution 2: Select the dimension,  Filter and Filter by Measure, then select « Reset »

 

Filter by using the BEx Conditions

Conditions are special pre-defined (at the query creation) dynamic filters that can be activated or deactivated in the report.

If conditions exist for the report, you can click on the "Filter" menu, then go to "BEx conditions" and selecting one from the list.

 

Filter out Zeros in Rows or Columns

In some cases, the BW report will still display a row or column even if all the values are equal to 0. This is usually the case when the "0" is the result of a sum of positive and negative numbers.

You can choose to remove those columns/rows via the "Suppress Zeros in Rows" and "Suppress Zeros in Columns" options in the Filter menu.