OBIEE 11g: When Exporting More Than 15 Digits To Excel, Precision May Be Lost And Rounded Up
(Doc ID 2123418.1)
Last updated on DECEMBER 22, 2020
Applies to:Business Intelligence Suite Enterprise Edition - Version 220.127.116.11.150714 and later
Information in this document applies to any platform.
The OBIEE 18.104.22.168.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
Because Excel only supports a maximum of 15 significant digits, numbers exported with more than 15 significant digits may lose precision.
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 22.214.171.124.x documentation does not mention this information.
Does this information also apply to OBIEE 126.96.36.199.x?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document