BI Publisher - Selecting 'All' in Parameter does not return any data
Summary:
We have created a BIP model parameter in such a way that when all values are selected, Null will be passed. We are handling this condition in the data model query with COALESCE or NVL or IS NULL functions, but none of them is returning any results.
Content (required):
Hi Team,
We have created a BIP model parameter in such a way that when all values are selected, Null will be passed (I believe there was another option of 'All will be passed' but somehow it's not available in OAC). We are handling this condition in the data model query with COALESCE or NVL or IS NULL functions, but none of them is returning any results. When we explicitly select all the values in the parameter (without selecting 'All') then it's returning the results correctly. Tried this with multiple Oracle and non-Oracle data sources. Can anyone help here, please?
Version (include the version you are using, if applicable):
6.2
Code Snippet (add any code snippets that support your topic, if applicable):