Monday, July 28, 2008

OBIEE Protect Filter

I had to make demo on protecting filters for a small class I gave.
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.
Till Next Time


Anonymous said...

DOH! I Needed this functionality. We ended up restriction the selections to ensure thart users did not select a department which should never be shown, because the filter was not protected


John Minkjan said...

Hi Soren,

Glad I could help ;-)

Best regards John

Anonymous said...

We have a dashboard with the prompt for the FY and one of the reports on the dashboard should show results for selected FY and previous FY. Report has filters Fiscal Year is greater than or equal to PREVIOUS_FSCL_YEAR AND Fiscal Year is less than or equal to CURRENT_FSCL_YEAR. However if filters are not protected report will display only results for FY selected in prompt but if they are protected it will then ignore prompt. Any idea how to resolve this issue? We need this solution if FY 2009 is selected in the prompt report will display results for FY2008 and FY2009 or if FY 2010 is selected report will display results for FY2009 and FY2010.

John Minkjan said...

Did you try use a prompt based filling a presentation variable and then calculating the two years.



Anonymous said...

I'm not quite sure what you mean. Can you please explain it to me with some more details.

Anonymous said...

In my report I created filter "Fiscal Year is greater than or equal to CAST(@{FY}{2009}-2 AS CHAR) and Fiscal Year is less than or equal to @{FY}{2009}" ,created prompt for @FY in dashboard and got exactly what I needed.

Thanks for the hint,

Anonymous said...


do I understand correctly that this effectively renders the prompt ineffective ?
I guess my question is, do you have a case to explain the usefulness of this feature ?

John Minkjan said...


This feature is espcially usefull if you have an "OR" filter.


Muhammad Waseem Shahzad said...
This comment has been removed by the author.
Muhammad Waseem Shahzad said...

We have a report that has around twenty "OR" criterias and ten "AND" criterias. All the filters are logically correct but report is returning invalid data. However if we reduce some filters then report works fine.

Any ideas of increasing filters limit for a report or reason of the issue.

Please need your help urgent.