OBIEE Protect Filter

Post date: 07-Apr-2011 08:57:25

Ref: http://debaatobiee.wordpress.com/2009/10/25/obiee-protect-filter/

 http://obiee101.blogspot.com/2008/07/obiee-protect-filter.html

This ensures that the filter used in the request is not lost or overwritten by another filter or dashboard prompt that may supersede the request.

This option is only available if a value has been specified in the filter. If the filter item is set to “is prompted” then the Protect Filter option if not available.

To apply it on the filter in the Answers Request, select Filter Options button > Protect Filter.  See below :

Nice example by debashish on his blog

Let's start with a simple report against the SH repository:

Put in a basic OR filter

Have a look a the result:

Make a basic prompt:

Put it all on a dashboard:

Select the year 2000:

You will see that you loose the "OR" function.

Now go back to your report on the first filter part check the Protect Filter option:

Save your report and go back to the dashboard. Select the year 1999 and press go.

You will see that the "OR" part stays intact.

Now go back to your report on the second filter part check the Protect Filter option:

Save the report and go back to your dashboard. Whatever year you select the result will not change.