OBIEE - Filter

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Server (OBIS|nqsserver|nqs)

1 - About

A filter in OBIEE can be either points to:

2 - Article

Advertising

3 - Snippet

3.1 - How to return data when the presentation variable is Null

Example with a presentation_variable

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

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

3.2 - How to protect a filter ?

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

3.2.1 - Example

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 :

Advertising

4 - Support

4.1 - Assertion failure: filterexprsqlvisitor.cpp

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