Business Objects 4.1 Webi Report Results Time Zone Adjustment

[Former Member]

Good day,

Currently using BO 4.1 SP7. (will be moving to 4.2 soon)

When pulling dates in Web Intelligence, the data returns GMT. I am looking for a way to adjust the date field reporting objects so that they return results in Central Time, and account for Daylight Saving Time. Currently, I can add "-6/24" to the select statement for the date object in the universe, and if it was submitted recently(after DST ended), the correct time displays. This does not account for records submitted during daylight saving time, as they are still one hour off.

Any suggestions on how to adjust the reporting objects to account for this time?

Thank you.

[Joe_Peters · Accepted solution]

Oracle? If so, the following is what I use:

cast(from_tz(cast(<<date field>> AS TIMESTAMP),'GMT') at time zone 'US/Eastern' as date)

[Former Member · Accepted solution]

I am going to try this in our test environment. I'll follow up soon.

Thank you!

[Former Member · Accepted solution]

Works great in test. Thanks for the solution!

[former_member185603]

Login to BI Launchpad, Preferences -> Locales and Timezones, Change the option Current time zone to your time zone.

[Former Member]

Thanks for the response.

That setting is set correctly, with no impact on the data that is being returned.