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!

OBIEE comparing null values in CASE stmt

ssk1974May 6 2011 — edited May 6 2011
Hi,

I have the following case statement, which gives me an error "[nQSError: 10058] A general error has occurred. [nQSError: 22027] Union of non-compatible types. (HY000)". "Response Date" is a DATETIME field.

CASE "Main Fact"."Response Date" WHEN NULL THEN '01/01/1800 12:00:00 AM' ELSE "Main Fact"."Response Date" END

I also tried IFNULL, and that did not work either. I am trying to insert the date field '01/01/1800 12:00:00 AM' if the date field has NULL values in it. Please let me know what I am doing worng.

Thanks for your time and help.
This post has been answered by David_T on May 6 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 3 2011
Added on May 6 2011
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
2 comments
4,818 views