Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Need to remove the NULL option value from OTBI dependent prompt

Received Response
163
Views
1
Comments

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.


Answers