Advanced Filtering

Advanced Filtering lets you create story and page filters based on multiple dimensions by defining a set of logical conditions.

The dimensions used in Advanced Filtering can be filtered by using AND or OR conditions. These conditions can be set to Include or Exclude the data that satisfies the filter conditions.

You can apply Advanced Filters by creating dimension tuples. A dimension tuple consits of a condition which contains a number of dimension filters. If the dimension members are different the result will create an asymmetrical filter.

Currently, advanced filtering can be used with Story and Page filters.

Note

If you're filtering a planning model, some empty cells that don't support data entry may not be grayed out. A message will appear when you try to enter data in these cells. See Troubleshooting Data Entry Errors for details.

Procedure

Page and story filters are enabled only after you've added at least one chart to your story

  1. Apply an advanced filter in one of these ways:
    • For a story filter, select (Story Filter) on the top navigation panel. In the resultant navigation panel, select Advanced Filtering.
    • For a page filter, select Start of the navigation path (Input Control) Next navigation step Advanced FilteringEnd of the navigation path on the top navigation panel.
  2. Start with an OR operator.
  3. Add additional AND or OR operators directly under the top operator.

    Adding additional operators will determine the number of dimension tuples desired for the filter.

  4. Add some dimensions beneath each AND or OR condition, and define different members for each dimension.
  5. Determine which operators the viewer should have control to turn off and make sure Allow viewers to disable the condition has a checkmark next to it.

    Each operator condition has a setting to allow users to disable the condition. When the story is opened in View Mode and the advanced filter token is selected, each operator has a checkbox and the viewer can choose to enable or disable the conditions within View Mode.

  6. Select OK to save the filter.
Operator types
The following operators can be used in advanced filtering
Operator Description
AND When all conditions are satisfied, the results will be filtered.
OR When any condition is satisfied, results from every successful condition will be filtered.
Exclude AND When all conditions are satisfied, the results will be excluded.
Exclude OR When any condition is satisfied, the results from every condition will be excluded.

Example

Suppose you want to create a filter which will always exclude the historical plans or forecasts, but will also include the plans and forecasts of the selected or current period.
Chart before applying Advanced Filtering
  1. Set the outer operator to an OR.
  2. Create 2 inner AND operators.
  3. Add your Time & Version dimension to the AND operator.
  4. Define the member tuples for each operator, so that one tuple has Historical data + Actuals & the other one is Current period + Plan.
Chart after applying Advanced Filtering

Example

Suppose you have a chart showing multi-dimensional data (for example, all products in the major regional areas) and you want to filter different sets of products for each regional area.
Chart before Applying advanced Filtering
  1. Set the outer operator to Exclude OR – this will exclude data for each successful condition.
  2. Create 2 or more inner AND operators.
  3. Add your Region & Product dimension to each AND operator.
  4. In each adjacent operator define a different region + product tuple.

In this example, the first tuple will exclude Apparel & Accessories from North and South America, the second tuple is going to exclude Apparel & Footwear from Asia Pacific, and the third tuple is going to exclude Apparel from EMEA. Our chart will now show the specific product members of each region.

Chart after applying Advanced Filtering