Sunday, 29 December 2013

OBIEE 11g - When Exporting to Excel, Cells are Merged if the Report Contains a Column in the Sections Layout

With OBIEE 11g earlier version, there seems to be problem when exporting to Excel, the cells are getting merged if the report contains a column in the Sections layout. This blog is an attempt to explain work around and also check if this issue has been resolved in latest version of Oracle Business Intelligence This is blog is based on Oracle Technical Note 1476160.1

Down Load with OBIEE to

OBIEE Report  &  Report Layout – Pivot Table

Download Issue
When export to Excel, the first column Product Type is exported into 2 merged columns in Excel (Column A & Column B). This is a bug for both Excel 2003 and 2007.

Work Around
As a workaround, you can add a dummy column at the beginning of the measure section. This way this dummy column is split in 2 Excel columns and not an important column.

Down Load with OBIEE

I have got the VM for OBIEE , I have tried similar report and exported into Excel 2007. The exported report is as follows.

No comments:

Post a Comment