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!

how to convert Null value to 0 after outer join?

YalaMar 25 2010 — edited Mar 25 2010
Hello guys

My requirement is to outer join 2 fact tables (that's the way it is), and i got the outer join working fine, so in my report, i have null values from measures in another fact table as a result of the outer join..

Is there a way I can convert those null values to 0?

I realized that the null isn't stored in the table, it is merely as a result of the outer join since the nulls are not matching records in the other fact.. So by default, i am expected to get nulls..

Is there way to present these null values to 0?

Many thanks for your advice
This post has been answered by PeakIndicators_Alastair on Mar 25 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 22 2010
Added on Mar 25 2010
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
2 comments
1,018 views