Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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

Sharmava
Rank 3 - Community Apprentice
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.
0
Answers
-
Use COALESCE function in the Data model for the parameters, rather than NVL
0