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 11.1.1.7.0 and later
Business Intelligence Answers Option - Version 11.1.1.7.0 and later
Oracle Exalytics Software - Version 1.0.0.3.0 and later
Business Intelligence Server Enterprise Edition - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Goal

Is there way you can un-merge cells (rows) when exporting to Excel in 11.1.1.7?  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:

Solution

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