Hi Everyone
I face with a very strange issue related to TimeZone in OBIEE 12C (12.2.1.4.0)
I create a analysis include:
+ A title with @{system.currentTime}
+ A table with a datetime column from OBI model (rpd), my db is Oracle 12C (with DBTIMEZONE:+00:00, and SESSIONTIMEZONE: +00:00)
1. My TimeZone instanceconfig.xml
<TimeZone>
<DefaultDataOffset>0</DefaultDataOffset>
<Logging>(GMT+07:00) Bangkok, Hanoi, Jakarta</Logging>
<DefaultUserPreferred>(GMT+07:00) Bangkok, Hanoi, Jakarta</DefaultUserPreferred>
<DefaultDataDisplay>(GMT+07:00) Bangkok, Hanoi, Jakarta</DefaultDataDisplay>
</TimeZone>
- TimeZone in my account is "(GMT+07:00) Bangkok, Hanoi, Jakarta" too
- The result is:
+ @{system.currentTime}: correct. same os time(GTM+7).
+ Datetime column in analysis: 7hours greater than value in DB.
+ Datetime column in xlsx export from analysis: the same value display in analysis.
- I changed Timezone to "(GMT) Casablanca, Monrovia" in My Account(see image), here is the result:
+ @{system.currentTime}: 7hours less than os time.
+ Datetime column in analysis: 7hours greater than value in DB.
+ Datetime column in xlsx export from analysis: the same value in DB.
2. I change change TimeZone config in instanceconfig.xml to:
<TimeZone>
<DefaultDataOffset>420</DefaultDataOffset>
<Logging>(GMT+07:00) Bangkok, Hanoi, Jakarta</Logging>
<DefaultUserPreferred>(GMT+07:00) Bangkok, Hanoi, Jakarta</DefaultUserPreferred>
<DefaultDataDisplay>(GMT+07:00) Bangkok, Hanoi, Jakarta</DefaultDataDisplay>
</TimeZone>
- The ressult is:
+ @{system.currentTime}: 7hours less than os time.
+ Datetime column in analysis: the same value in DB.
+ Datetime column in xlsx export from analysis: 7hours greater value display in analysis.
- I changed Timezone to "(GMT) Casablanca, Monrovia" in My Account, here is the result:
+ @{system.currentTime}: 14hours less than os time.
+ Datetime column in analysis: the same value in DB.
+ Datetime column in xlsx export from analysis: the same value display in analysis.
3. I change change TimeZone config in instanceconfig.xml to:
<TimeZone>
<DefaultDataOffset>0</DefaultDataOffset>
<Logging>(GMT+07:00) Bangkok, Hanoi, Jakarta</Logging>
<DefaultUserPreferred>(GMT+07:00) Bangkok, Hanoi, Jakarta</DefaultUserPreferred>
<DefaultDataDisplay>(GMT) Casablanca, Monrovia</DefaultDataDisplay>
</TimeZone>
- The ressult is:
+ @{system.currentTime}: the same os time.
+ Datetime column in analysis: the same value in DB.
+ Datetime column in xlsx export from analysis: 7hours greater value display in analysis.
- I changed Timezone to "(GMT) Casablanca, Monrovia" in My Account, here is the result:
+ @{system.currentTime}: 7hours less than os time.
+ Datetime column in analysis: the same value in DB.
+ Datetime column in xlsx export from analysis: the same value display in analysis.
Please help me solve this issue.
Thanks