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!

Issue with Data Precision in Essbase on parent level members

3336830Aug 22 2017 — edited Aug 22 2017

Hi Gurus,

We are observing a strange issue where we have data differences from 11th digit. This variance is when we do our recon between 11.1.2.1 vs 11.1.2.4 system. Below are the type of variances which we are getting.

pastedImage_0.png

Also the data is also not summing up correctly to parent level. The amber one is 11.1.2.4 retrieval. ( the green tab line is the sum of the amber values) . If we see it is not summing up correctly to precision 9th digit and ahead. Similarly in 11.1.2.1 ( white retrievals) data isn't correctly summing up from 9th digit onwards to its parent.

pastedImage_3.png

According to Oracle document "The Limits of Data Precision in Essbase (Doc ID 1311188.1)" data should be correctly available till 15th digit.

Note: I do know and understand these are very tiny differences but this was been highlighted as an issue for us..

Regards,

VS
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 19 2017
Added on Aug 22 2017
#business-intelligence-applications, #epm-system-infrastructure, #performance-management-applications
6 comments
666 views