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!

Removing NULL value from dashboard prompt

Shantanu RBJul 18 2011 — edited Dec 8 2011

Hi,

I have a dashboard prompt to display the region name but display only those regions those are active.......I have applied a query
CASE WHEN "D01 Store Dim"."Effective To Date" IS NULL AND "D01 Store Dim"."Current Man Region" IS NOT NULL THEN "D01 Store Dim"."Current Man Region" End

This does display the right result except that at the bottom i'm also getting '(NULL)' value displayed. how can we hide this?

Your help and advice is appreciated!!

Cheers,
Shan

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 5 2012

Added on Jul 18 2011

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

9 comments

429 views