OBIEE 11g|12c: Some Timestamp Format May Not Be Exported Correctly To Excel 2007+
(Doc ID 2390187.1)
Last updated on APRIL 02, 2020
Applies to:Business Intelligence Server Enterprise Edition - Version 220.127.116.11.150714 and later
Information in this document applies to any platform.
On OBIEE 18.104.22.168, 22.214.171.124 and 12c :
When you display an analysis with custom timestamp format, the date column is displayed as expected format in browsers.
However, when tried to export the analysis to Excel 2007, some date column may not be displayed in Excel.
For example, when you set 'MM/dd/yyyy tt hh:mm:ss' as custom timestamp format in an analysis and export it to Excel 2007+ using OBIEE 11g, it is displayed as "04/24/2018 tt 16:39:36" in Excel.
When exporting the analysis to Excel 2007+ using OBIEE 12c, it will be displayed like '43194.36988' in Excel.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document