My Oracle Support Banner

Oracle Exalytics and OBIEE 11.1.1.6.X Analysis Does Not Retain Custom Date Format (YYYYMMDD) When Exported To Excel Or Comma Separated Values (CSV) (Doc ID 1565415.1)

Last updated on FEBRUARY 11, 2020

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.6.5 to 11.1.1.6.12 [Release 11g]
Oracle Exalytics Software - Version 1.0.0.2.0 and later
Information in this document applies to any platform.

Symptoms

Created an Oracle Business Intelligence Enterprise Edition (OBIEE) analysis in OBIEE version 11.1.1.6.5.
Edited "Order Date" column properties in OBIEE and checked "Override Default Data Format".
Set Date format to use 'YYYYDDMM' format and saved analysis.

When running this report in OBIEE, the "order date" column displays the dates as expected (i.e. 20131220, 20130503, etc.).
If the Analysis is exported to Excel 2010 or to CSV format, the date format is not preserved.
Instead of seeing the formatted date, the CSV file shows "############" and Excel 2010 also shows "################".
If the Excel cell is clicked, the expected date will display in the formula bar (fx) area at the top of the worksheet, but it does not show the expected value in the actual cell.

Excel and OBIEE language settings are both set to English (US) as default.
The format on the Excel export is preserved if default date format is used.
This problem only happens when the custom date format is used - i.e. override default format; and when exported to CSV or Excel.

This problem also occurs in other versions of the OBIEE 11.1.1.6 product family (i.e. 11.1.1.6.8 and 11.1.1.6.10).

This problem may occur on standalone OBIEE environments and/or Oracle Exalytics servers that also include OBIEE.

Cause

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
Symptoms
Cause
Solution
References


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