How To Unmerge Cells After Exporting To Excel When The Cells Are Merged In Answers?
Last updated on JULY 01, 2016
Applies to:Business Intelligence Suite Enterprise Edition - Version 220.127.116.11.0 and later
Business Intelligence Answers Option - Version 18.104.22.168.0 and later
Oracle Exalytics Software - Version 22.214.171.124.0 and later
Business Intelligence Server Enterprise Edition - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
Is there way you can un-merge cells (rows) when exporting to Excel in 188.8.131.52? 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