Need to remove the NULL option value from OTBI dependent prompt

Sharmava

When we creating dependent prompt using "limit by" option in the OTBI prompt, NULL value gets appended in the list of values. If user is running with NULL parameter report goes into an invalid parameter error. Attached sample screenshot.

Requirement is to remove the null value from the prompt.

Null in LOV.docx

Prateek Dhawan

Use COALESCE function in the Data model for the parameters, rather than NVL