OBIEE - Filter

A filter in OBIEE can be either points to:

• a Logical SQL filter predicate (in Answer or in the repository)
• or to the Logical SQL filter function

• OBIEE - How to force a user to filter on a column A every time column B is in the request
• OBIEE - Filter on current time
• OBIEE - Regular Expression (Regexp) and how to filter on string pattern ?
• OBIEE 10G/11G - Conditional Filtering based on Presentation Service Variable

Example with a presentation_variable

Table.Column LIKE '@{MyPresentationVariable}{%}' 

You must use in the filter, the button Advanced/Convert this filter to SQL

When navigating or using a dashboard prompt, OBIEE applies to the conditional value of the predicate

• with the value of the dashboard prompt
• of with the value of the link

The filter below

Table.Column = 5 

will be replace if you ask for the value 7 with the dashboard prompt by : The filter below

Table.Column = 7 

To avoid this situation, you can protect your filter :

Assertion failure: !(ie == rExpr.childElements_end()) at line 1734 of /net/stasunnas09/export/ifarm_test
/ifarm_views/aime_bifndn_936475/bifndn/analytics_web/main/project/webreport/filterexprsqlvisitor.cpp

This error may caused when you suppress a filter from a report. To resolve this issue:

• get the Analysis XML, indent it and apply it again
• of you can try to suppress the <saw:filter></saw:filter> node from the Analysis Xml