OBIEE 12c: Database Data Time Is Not Taken And Data Timezone Is Shifted In The Analysis Results (Doc ID 2254874.1)

Last updated on JUNE 02, 2017

Applies to:

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

Symptoms

Applied the following patch in OBIEE 12.2.1.1:

25361232 MERGE REQUEST ON TOP OF 12.2.1.1.0 FOR BUGS 22647555 22819596 22835202 22932089

for bug:

25178299 FILTER TIME VALUE DISPLAY IS ADJUSTED FOR USER TIME ZONE PREFERENCES



After that, although the issue with Date Time filters is fixed, the following problem with the TimeZone is present:

The database server is located in EST. When the user won't select any TimeZone preferences in their account .i.e unknown TimeZone, then OBIEE analysis displays exact data time values it is getting from the database as there is no timezone preferences to shift +/-, convert the data to that timezone and display to the user.

However, in case when most of user preferences sets to EST, it is taking the EST data from the database, but its shifting the data GMT-5 again based on preferences the user selected.

OBIEE is not taking the database data timezone and displaying based preferences selected.

OBIEE needs to take the exact database data time if it is EST and if preferences is EST then it should display analysis in EST. Or if the user changes another preference that database data will come as EST, convert based on preference and display data in the report in that timezone.

Changes

Applied the following patch:

25361232 that contains fix for bug 25178299

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