Thursday 15 August 2013

OBIEE Protect Filter

"Protect filter" basically "hard-codes" a filter so that it won't be overwritten. 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.

Say ,I have created a report with filters on "Prod Category” Column 




I created a dashboard with prompt on "Prod Category" and placed the created report.
selected "Peripherals and accessories" values  from the prompt and results are as follows

I applied other filters("Electronics" ,"Hardware") as well but those were overwritten because filters are not protected.

So, Now I protected the filters("Electronics", "Hardware")  ,as shown in below image, and saved it.


Now, when I selected the value "Peripherals and accessories" from the prompt ,I can see the protected filter values as well as prompt filter values because filters are protected now.



Thanks.

No comments:

Post a Comment

A fatal error occurred while processing the request. The server responded with: FOProcessor cannot run without a valid TMP directory. Please check if TMP directory exist and write enabled.

When attempting to export a Dashboard to Excel the following error message in sawlog is found: A fatal error occurred while processi...