The feature was already there from OBIEE 10g versions. We need to take some extra precautions before applying this in request filters which can be adopted as best practice in report development.
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.
And The filter is looks like the this. With the "key" icon on the filter icon to lock the values to restrict the change.
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.
Select Filter Options button> Check the Protect Filter option as seen in the screen below...
What's bout unprotected filters in OBIEE ?
ReplyDeleteor What's the difference between protected & unprotected filters ?