Cells Are Suppressing In The Excel Export After Upgrade From OBIEE 126.96.36.199.7 to 188.8.131.52.140225
Last updated on AUGUST 11, 2014
Applies to:Business Intelligence Server Enterprise Edition - Version 184.108.40.206.140225 and later
Information in this document applies to any platform.
Performed an upgrade from OBIEE 220.127.116.11.7 to 18.104.22.168.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 22.214.171.124.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?
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