OBIEE 11g: String of Numbers Exported to Excel has Incorrect Scientific Format
Last updated on JANUARY 27, 2017
Applies to:Business Intelligence Server Enterprise Edition - Version 18.104.22.168.5 and later
Business Intelligence Suite Enterprise Edition - Version 22.214.171.124.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.
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