OBIEE 11g: String of Numbers Exported to Excel has Incorrect Scientific Format
(Doc ID 1673068.1)
Last updated on AUGUST 06, 2018
Applies to:Business Intelligence Server Enterprise Edition - Version 184.108.40.206.5 and later
Business Intelligence Suite Enterprise Edition - Version 220.127.116.11.5 and later
Information in this document applies to any platform.
In OBIEE 11g you have a character-based column which contains a string of only numbers, for example, "100310001010000220110103" in the results table. The column is defined in the Oracle database as Varchar(40).
When you export the results to Excel, you get an incorrect value "1,0031E+23" in scientific number format.
When you change the cell in Excel to a number format the following incorrect number is displayed 100310001010000000000000.00.
When you export the results to a tab delimited or CSV data format file, the correct data is stored in the file (open it in a text editor).
However if you the file is opened in Excel, then the data is displayed incorrectly as “1,0031E+23".
When the string value includes a character in the string then it is correctly exported to Excel and the problem is not reproduced.
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