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!

Ifnull - OBIEE analysis calculated fields not working

user13816768Jun 16 2014 — edited Jun 17 2014

Hi All,

I have a report in OBIEE 11.1.1.6.8 in UAT instance which is having huge calculations and all the fields are properly displaying.

The same report we have migrated to Production Instance 11.1.1.6.8 instance, but some of the calculated fields are missing values in it.

So after noticing the issue we found that 'Null' value in one of the dimension field (for eg., Project ID) is causing the issue, so we have include ifnull(ProjectID, 0).  Then the values populated in the missing value related fields.

But my question is, why the report worked in UAT instance without applying ifnull and why it is not working in production instance.

we have same RPD and Catalog in both the instances, and checked all the config files everything is same.

Any help will be appreciated

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 15 2014
Added on Jun 16 2014
#answers, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #obiee
1 comment
1,075 views