Implement daylight savings in OBIEE

[Imran]

Hi Guru's/Experts,

I am wondering how can we implement daylight savings in OBIEE 11g?

For example, we have 2 locales: south america and central U.S & Canada. They both are GMT -6, but when we actually change the locale to either, there are difference at this time of the year. South America displays GMT - 6 but Central America & canada is converting to GMT -5 despite the time zone still being GMT -6. This is probably due to date light savings in America..

So is there a system variable that captures daylight savings?

And also i need to convert Day light saving from GMT to PST,is there any predefine variables?

If I want to apply filters at hourly level or timestamp level, I will need to know the offset number that I can use to subtract from the GMT time..

--

Thanks,

--

Imran M

[Imran]

Any updates?

[Aål•k]

​In what context?  Running an Analysis or Agent? ​ Every User can set their own timezone in My Account. 

On Thu, Feb 19, 2015 at 11:48 AM, Imran <imra...@gmail.com> wrote:

[Aål•k]

Imran, 

Please take a look at the following and see if you can find what you are looking.. As there are some session variables related to timezones. 

http://docs.oracle.com/cd/E14571_01/bi.1111/e10541/configtimezones.htm#BIESG1297

Sincerely,

Alok

--
--
You received this message because you are subscribed to the Google
Groups "OBIEE Enterprise Methodology Group" group.
To post to this group, send email to
obiee-enterpri...@googlegroups.com
To unsubscribe from this group, send email to
obiee-enterprise-met...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/obiee-enterprise-methodology?hl=en
 
All content to the OBIEE EMG lies under the Creative Commons Attribution 3.0 Unported License (http://creativecommons.org/licenses/by/3.0/). Any content sourced must be attributed back to the OBIEE EMG with a link to the Google Group (http://groups.google.com/group/obiee-enterprise-methodology).

---
You received this message because you are subscribed to the Google Groups "OBIEE Enterprise Methodology Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email to obiee-enterprise-met...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Imran]

Hi Alok,

I am trying to show in report  all the time conversions + Day light Saving columns.

for example :

Login	GMT Column	PST Column	PST DLS	MST Column	CST Column	EST Column
Abc user	7:00 PM	11:00 AM		10:AM	9:00 AM	8:00 AM

NOTE: USER's dont want to setup they time zone as default to their local time.

[Joel Acha]

Hi Imran

You could use the EVALUATE function to call the Oracle NEW_TIME function (assuming your data source is Oracle). 

http://docs.oracle.com/cd/B19306_01/server.102/b14200/functions092.htm?__hstc=150481449.4459127b42e599f48e6485c5a71e1c33.1424840383428.1424840383428.1424840383428.1&__hssc=150481449.1.1424840383428&__hsfp=2118291806

Regards 

Joel

Sent from my iPad

[Imran]

Thanks Joel ...It works perfectly.

Thank you all