OBIEE 12c: Date Time Filter Value In Analysis Gets Adjusted To User Time Zone Preferences (Doc ID 2232048.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

The date and Time shown in the filter is the same as the System time +/- the time difference in the user profile (My Account -> Preferences -> Time Zone).

For example, if System is in GMT time zone and a user is in EST time zone, selecting 1/14/2012 12:00 am for a filter value and saving will show 1/13/2012 7:00 pm in the filter of the analysis.

Editing the filter and/or running the analysis will still properly show 1/14/2012 12:00 am.

Issue is how the filter time value is displayed once saved. Filter shows a date/time different than that which was selected.

Changes

Upgraded from OBIEE 11.1.1.9 to 12.2.1.1.

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