Forum Stats

  • 3,838,726 Users
  • 2,262,395 Discussions
  • 7,900,741 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

  • User_27DEY
    User_27DEY Member Posts: 214 Blue Ribbon
    edited Apr 29, 2020 2:39PM

    I run into the same issue after applied the April 202 PSU, we have opened p1 with Oracle for 6 days, no one has any idea so far.

  • DENISKA80
    DENISKA80 Member Posts: 10 Green Ribbon

    Same here.

    Obiee 12.2.1.4.

    Default settings

    Export to excel add 3h to datetime and timestamp

    with "(GMT) Casablanca, Monrovia" in My Account or <(GMT) Casablanca, Monrovia</DefaultUserPreferred>  in instanceconfig

    dates are exported correctly but @{system.currentTime} is incorrect.