OBIEE - Filter

1 - About

A filter in OBIEE can be either points to:

2 - Article

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 :

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

Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap