OBIEE 11g: When Exporting More Than 15 Digits To Excel, Precision May Be Lost And Rounded Up
Last updated on DECEMBER 03, 2017
Applies to:Business Intelligence Suite Enterprise Edition - Version 188.8.131.52.150714 and later
Information in this document applies to any platform.
The OBIEE 184.108.40.206.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 220.127.116.11.x documentation does not mention this information.
Does this information also apply to OBIEE 18.104.22.168.x?
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