OBIEE 11g: Columns are Merged into One Cell When Exporting to Excel 2007+ (Doc ID 1584051.1)

Last updated on MARCH 28, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.0 to 11.1.1.7.0 [Release 11g]
Oracle Exalytics Software - Version 1.0.0.3.0 and later
Business Intelligence Answers Option - Version 11.1.1.7.0 to 11.1.1.7.0 [Release 11g]
Business Intelligence Server Enterprise Edition - Version 11.1.1.7.0 to 11.1.1.7.0 [Release 11g]
Information in this document applies to any platform.

Symptoms

When exporting an Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.7.0 report or dashboard to Excel 2007+, two of the report columns are merged into a single cell.

The value for each column should be shown in it's own separate cell, but in the Excel output two adjoining columns are merged into a single cell as shown in the screen shot below:

 

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