OBIEE 11g: When Exporting More Than 15 Digits To Excel, Precision May Be Lost And Rounded Up (Doc ID 2123418.1)

Last updated on APRIL 04, 2016

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.150714 and later
Information in this document applies to any platform.

Goal

The OBIEE 11.1.1.9.x Release Notes documentation mentions about "15 significant digits" when export to Excel from OBIEE

Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition
Export Menu Options for Views and Results

------------------
Notes:
Because Excel only supports a maximum of 15 significant digits, numbers exported with more than 15 significant digits may lose precision.
------------------


For example:

Create a column in Answers (with a decimal position set to 15) and hard-coded a value of 12345467890123456789.515, Answers will round this up, so that the display on the results tab was 1234567890123460000.000

OBIEE 11.1.1.7.x documentation does not mention this information.

Does this information also apply to OBIEE 11.1.1.7.x?


 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms