OBIEE 11.1.1.9.0 - Export To Excel 2007 Not Displaying Data Values in cells of the downloaded Excel file (Doc ID 2099611.1)

Last updated on OCTOBER 09, 2017

Applies to:

Symptoms

On : Oracle Business Intelligence (OBIEE) 11.1.1.9.0 version, Analytics,

When downloading report to Excel from an upgraded report

• The downloaded Excel report does not display the values in cell. But the values do exist in cells.
• This issue is seen only with PIVOT table reports download.
• Non-pivot reports download to excel is displaying values correctly.
• When downloading same report in 11.1.1.6.9 to excel, it displays all values correctly.
• Expected behavior is that the downloaded reports must show the data value in same raw format.
• Applying custom data formatting to a column in OBIEE does not work as expected when the data is exported to Excel.
• Adding custom data formatting, such as '#,' to a column, works as expected in OBIEE. However, when the data is exported to Excel it applies the custom data formatting again to the already formatted data, as in twice, which is equivalent to applying '#,,'
  For example, Data 1000000 with formatting '#,' -> OBIEE results show 1000 -> Same when exported to Excel shows 1

Changes

 Upgrade from 11.1.1.6.9 to 11.1.1.9.0

Cause