OBIEE 11.1.1.7.150120 - EXCEL 2007+ Exports Wrong Date Format For Non-ENU (Doc ID 2007856.1)

Last updated on MAY 19, 2016

Applies to:

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

Symptoms

Date fields exported to Excel 2007+ do not retain the same date format as Answers reports. The day and month elements of the Excel output was switched around from the Answers output. Date fields exported to PDF and Excel 2003 work correctly.

 

 

 

Changes

The issue occurs when switching the Answers Language setting different from the Windows Locale.

Steps to reproduce the issue:

In OBIEE Server environment (ENU), log in to Answers (using Sample Sales Lite RPD) as 'Deutsch' Language.
Create simple report of 1 column; Time.Calendar Date.
Answers Results displays Calendar Date as: 01.10.2006

Export to Excel 2003 and Calendar Date is correctly displayed as: 01.10.2006

Export to Excel 2007 and Calendar Date is incorrectly displayed as: 10/01/2006

Here we see the date format for Excel 2003 and 2007 are different for DEU and that dd.mm have been switched to mm/dd

This also occurs if you log in to Answers as 'French' language, so not specific to DEU.

Cause

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