OBIEE 11g/12c : Excel 2007+ Export Does Not Honour OBIEE Time Zone Preference And/Or Offset Configuration

(Doc ID 2375514.1)

Last updated on JULY 09, 2018

Applies to:

Business Intelligence Reporting and Publishing - Version 11.1.1.9.170418 and later
Information in this document applies to any platform.

Symptoms

Timezone offset has been configured in BI Presentation Service component in instanceconfig.xml configuration file by referring Doc ID 953881.1

For example , with above configuration -

Timestamp attribute is showing following value : 20.2.2017 12:08:41 (while in database there is following value stored: 20.2.2017 7:08:41)

Timestamped data shifted (correctly) by 5 hours

When same report is exported into Excel2007+ , instead of having the same timeshift of 5 hrs as can be sees in OBIEE UI , data are shifted in Excel just for only 1 hr (preferred timezone applied) or for 4 hrs (Offset timezone applied)

Analytics application is showing expected date but when same report is exported to excel 2007+ , there is difference in date/time values.
Issue did not resolve even after applying Patch 26551922

Changes

1. Timezone offset has been configured in OBIPS instanceconfig.xml file

2. Timezone preference has been set under my account > preferences or configured in OBIPS instanceconfig.xml

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