OBIEE 11g: After an Export to Excel the Graphs Overlap Each Other and Obscure the Data (Doc ID 1342529.1)

Last updated on SEPTEMBER 28, 2016

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.5.0 [1308] and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.5.0 [1308] and later
Information in this document applies to any platform.

Symptoms

You have a report with a number of graphs.  You export it to Excel, but the following message is displayed by Excel when trying to open the export:

The file you are trying to open, filename.xls, is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?

After clicking 'Yes' and opening in Excel 2003+, the graphs are misplaced and overlap or overlay each other and the data displayed.

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