Essbase Data precision unraveled
By Torben Hein -Oracle on Mar 26, 2012
(guest reference added by Nancy)
Anyone who has been working with Data import and exoport as well as the Essbase Excel Add In has probably come across a phenomenon that is called data precision:
Lots of zeroes are added to any given number that has been calculated by Essbase, and this gets displayed as "10.0000000000001" or "9.99999999999999" instead of a simple "10" .
This question is one of the recurring ones that Support get asked over and over again, and we therefore feel the need to give an explanation to it:
I would like to point you to the note The Limits of Data Precision in Essbase (Doc ID 1311188.1) which explains in detail why these numbers are showing up and what to do about it.