OBIEE 12c: Database Data Time Is Not Taken And Data Timezone Is Shifted In The Analysis Results
Last updated on JUNE 02, 2017
Applies to:Business Intelligence Reporting and Publishing - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
Applied the following patch in OBIEE 188.8.131.52:
25361232 MERGE REQUEST ON TOP OF 184.108.40.206.0 FOR BUGS 22647555 22819596 22835202 22932089
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.
Applied the following patch:
25361232 that contains fix for bug 25178299
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