Protecting Filters

The Protecting Filters Option in Oracle BI or Oracle Analytics Cloud is usually not used or needed. However, it may be required when using multiple Filters on the same Column (Subject area Field) and using Action Links as Drill-down navigation or in conjunction with Dashboard Prompts.

image

The following is an example scenario without protecting the Filters: On the Detailed Report, the following Operators are defined:

image

When making the Drill-down from the Top Report using the Action-link Drill-down navigation:

image

The Filter Operators are overwritten by the internal Background process for navigating to the Detail Report (compare Operator which is “is equal to / is in” which should have been “is less than or equal to” from Report definition):

image

After selecting “Protect Filter” the Operator is protected from the Background navigation process and the intended Operator is used on the Detailed Report:

image

This feature is also described in the following article:

Advertisements