How To Unmerge Cells After Exporting To Excel When The Cells Are Merged In Answers?
(Doc ID 1930660.1)
Last updated on JANUARY 15, 2020
Applies to:Business Intelligence Suite Enterprise Edition - Version 126.96.36.199.0 and later
Business Intelligence Answers Option - Version 188.8.131.52.0 and later
Oracle Exalytics Software - Version 184.108.40.206.0 and later
Business Intelligence Server Enterprise Edition - Version 220.127.116.11.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 18.104.22.168? 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document