End users ask many times to change the default configuration in Analysis for cells.

Why : because per default, all cells are merged and if you want to export to Excel, End users are not able to add filter.

This Document explains how to unmerge cells only when you export to Excel.

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:….

Categories: OBIEE

Tags: excel, obiee