OBIEE 11g - Export to Excel - Repeat Cell Values

An annoying little feature in OBIEE 11g export to excel is, it preserves the column level "suppress values" setting in the report.

This will be very frustrating for users, especially when you export to Excel and use the data for further analysis through Pivot Table.

This can be easily overcome by adding few tags to the instanceconfig.xml file on the server.

#1 - Add the below name space to the WebConfig tag -
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

After making the change, it should look as below:

          

#2 - Add below tags to the file -

Save Changes.

Restart Presentation Services.

After this change, when exported to Excel the cell values will be repeated even if the setting on the report is "suppress values".