My Oracle Support Banner

OBIEE 11g|12c: Some Timestamp Format May Not Be Exported Correctly To Excel 2007+ (Doc ID 2390187.1)

Last updated on SEPTEMBER 03, 2021

Applies to:

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


On OBIEE, 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.