Cells Are Suppressing In The Excel Export After Upgrade From OBIEE to

(Doc ID 1681540.1)

Last updated on AUGUST 11, 2014

Applies to:

Business Intelligence Server Enterprise Edition - Version and later
Information in this document applies to any platform.


Performed an upgrade from OBIEE  to version.

After this version upgrade, in the OBI Reports when the users are trying to export the reports to Excel the cells are suppressing.

Where as in the when export to Excel, for each row the value for each column used to appear, there by users can analyze the exported report using Sort or Filter options.

After upgrade the values are suppressing and users are not able to do Sort option.

As a work around we had changed the Column Property of the OBI Report columns from "Suppress" to "Repeat" option and then after exporting the cells repeated for each record.

But there are so many reports where we might have used this "Suppress" option in the column properties that this workaround is very time and resource consuming.

How to disable "Suppress" option for all reports at once?



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