Timezone does not work in OBIEE reports

1976478

Hello Everyone,

I am trying to use the OBIEE Timezone functionality in the reports.

I added below tag in INSTANCECONFIG xml, as per Oracle documentation.

<TimeZone>

     <DefaultDataOffset>0</DefaultDataOffset>

     <Logging>(GMT) Casablanca, Monrovia</Logging>

     <DefaultUserPreferred>(GMT) Casablanca, Monrovia</DefaultUserPreferred>

     <DefaultDataDisplay>(GMT) Casablanca, Monrovia</DefaultDataDisplay>

</TimeZone>

But in the report, the timestamp still does not change when I change the TIMEZONE from MY ACCOUNT in OBIEE.

Please let me know if I am missing any step, or if there is step by step documentation available on this.

Thanks.

SriniVEERAVALLI

If column is in datatype datetime then that should work.

I would suggest check the datatype.

1976478

Hi Srini,

Thanks for the reply.

I did checked the data type, and it is DATETIME. I even tried with TIMESTAMP datatype just to check, but no luck.

Is there any other possible reason?

Thanks

SriniVEERAVALLI

try to set just this and see how that works

<TimeZone>

<DefaultDataOffset>0</DefaultDataOffset>

</TimeZone>

1976478

Thanks Srini.

That worked.

SriniVEERAVALLI

mark it as correct. that would close the post and helps other with similar issue.

SriniVEERAVALLI

Can you share correct answer for this? since you able to see values as expected.

I would like to know if the fix is other than suggested!!