Forum Stats

  • 3,769,241 Users
  • 2,252,938 Discussions
  • 7,874,958 Comments

Discussions

Please help the issue related to TimeZone in OBIEE 12C

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:pastedImage_22.png

          + @{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

Tagged:

Answers