With OBIEE 11g earlier version 220.127.116.11.0, 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 18.104.22.168.1. This is blog is based on Oracle Technical Note 1476160.1
Down Load with OBIEE 22.214.171.124.0 to 126.96.36.199.8
OBIEE Report & Report Layout – Pivot Table
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.
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 188.8.131.52.1
I have got the VM for OBIEE 184.108.40.206.1 , I have tried similar report and exported into Excel 2007. The exported report is as follows.