Timezone does not work in OBIEE reports

1976478 · Jul 11, 2016 5:28AM

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.

<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 · Jul 12, 2016 9:22AM

If column is in datatype datetime then that should work.

I would suggest check the datatype.

1976478 · Jul 13, 2016 5:41AM

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 · Jul 13, 2016 9:07AM

try to set just this and see how that works

</TimeZone>

1976478 · Jul 20, 2016 5:46AM

Thanks Srini.

That worked.

SriniVEERAVALLI · Jul 20, 2016 9:03AM

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

SriniVEERAVALLI · Jul 21, 2016 9:16AM

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!!

Oracle Business Intelligence Applications