Cells Are Suppressing In The Excel Export After Upgrade From OBIEE 11.1.1.6.7 to 11.1.1.7.140225 (Doc ID 1681540.1)

Last updated on AUGUST 11, 2014

Applies to:

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

Goal

Performed an upgrade from OBIEE  11.1.1.6.7  to 11.1.1.7.140225 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 11.1.1.6.7 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?

 

Solution

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