Essbase Data precision unraveled

Posted by THE on Oracle Blogs See other posts from Oracle Blogs or by THE
Published on Mon, 26 Mar 2012 03:53:45 -0500 Indexed on 2012/03/26 11:38 UTC
Read the original article Hit count: 327

Filed under:

/EPM / Bi

(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.

Related posts about /EPM / Bi

EPM 11.1.2 - EPM Infrastructure Tuning Guide v11.1.2.1

as seen on Oracle Blogs - Search for 'Oracle Blogs'
Applies To: This edition applies to only 11.1.2, 11.1.2 (PS1). One of the most challenging aspects of performance tuning is knowing where to begin. To maximize Oracle EPM System performance, all components need to be monitored, analyzed, and tuned. This guide describe the techniques used to monitor… >>> More
EPM 11.1.1 - EPM Infrastructure Tuning Guide v11.1.1.3

as seen on Oracle Blogs - Search for 'Oracle Blogs'
This edition applies to EPM 9.3.1, 11.1.1.1, 11.1.1.2 & 11.1.1.3 only. INTRODUCTION:One of the most challenging aspects of performance tuning is knowing where to begin. To maximize Oracle EPM System performance, all components need to be monitored, analyzed, and tuned. This guide describe the… >>> More
I'm Not Bi-Polar, I'm Bi-Winning

as seen on Oracle Blogs - Search for 'Oracle Blogs'
On March 1st, Charlie Sheen joined Twitter and was able to amass 1M followers in 25 hours and 17 minutes, setting an official world record. So why does it take your brand so long to collect followers? Easy: you're brand isn't a train wreck.Wouldn't it be great if your customers we chatting… >>> More
Information Builders lance WebFocus Mobile BI, sa solution BI pour Smarphones et tablettes

as seen on Developper.com - Search for 'Developper.com'
Information Builders lance WebFocus Mobile BI Sa solution BI pour Smarphones et tablettes Information Builders annonce le lancement de WebFOCUS Mobile BI, sa nouvelle solution de Business Intelligence qui permet de bénéficier des fonctionnalités analytiques sur mobiles via n'importe quel terminal… >>> More
EPM System Standard Deployment Video Series

as seen on Oracle Blogs - Search for 'Oracle Blogs'
(in via Jan) A four-part video series on deploying Enterprise Performance Management (EPM) System Products has been made available within the Oracle EPMWebcasts YouTube channel. This video series is designed for system administrators. It provides an… >>> More

Developer IT