OBIEE 11g: String of Numbers Exported to Excel has Incorrect Scientific Format (Doc ID 1673068.1)

Last updated on JANUARY 27, 2017

Applies to:

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

Symptoms

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.

Cause

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