How To Unmerge Cells After Exporting To Excel When The Cells Are Merged In Answers?

(Doc ID 1930660.1)

Last updated on JULY 01, 2016

Applies to:

Business Intelligence Suite Enterprise Edition - Version and later
Business Intelligence Answers Option - Version and later
Oracle Exalytics Software - Version and later
Business Intelligence Server Enterprise Edition - Version and later
Information in this document applies to any platform.


Is there way you can un-merge cells (rows) when exporting to Excel in  You want to keep merge format on the dashboard, but unmerge only when exporting to Excel.

For example, the OBIEE report is  doing a group sort by year, brand and then a sum by individual office.   With this group sort, the year and brand value are not repeated in each row and only display when the brand or year changes as shown in the screen shot below:


When  exported to Excel, it retains the distinct group sort look of the OBIEE  report, as shown below, but the preferred Excel display is to repeat the group sort columns in every row so that every cell in every row has a value.


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