Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

yes no prompt column null-value

Sydney DOct 15 2009 — edited Oct 22 2009
I want to have a yes/no (dashboard) prompt on a column to distinguish between null and not null values of the column,
so that the user can filter out null-values of the column.
I created a prompt and in the formula(Fx) I wrote:
CASE WHEN <column_name> IS NULL THEN 'YES' ELSE 'NO' END
But now I am at a loss how to continue, the (value)-filter doesn't seem to work with the report.

Greetings.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 19 2009
Added on Oct 15 2009
#bi, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #dashboard, #prompt, #report
5 comments
1,022 views