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!

Display 0 value if data doesn't exist in fact table obiee 11g

prassuDec 3 2014 — edited Dec 4 2014

Hello,

I have a requirement to show the 0 if the data is not available in fact table.

I have a sales fact,time ,location dimensions in my report. For Aug2014 month I don't have any sales for US location. My requirement is when user selects aug2014 and US location the sales columns should show 0 as value.

I tried with Outer joins in RPD but no luck..Can anyone please help me out here.

Thanks,

Prasanna

This post has been answered by Gianni Ceresa on Dec 4 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 1 2015

Added on Dec 3 2014

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

6 comments

1,968 views