You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

User Time-Zone in BI Publisher Excel Template

24
Views
3
Comments
edited Jun 4, 2020 2:44PM in General Transactional Reporting (OTBI) 3 comments

Summary

User Time-Zone Management in Bi Publisher

Content

Hi, I am creating a report which has to extract a field which is managed with TIMESTAMP. Since this report should be used across many countries, I would like to display the filed with the correct time-zone of the user who launches the report.

I am developing a standard BI Publisher Data Model and an Excel template as layout. I have reviewed many whitepaper, which suggested to work with following attributes in the data model:

SESSIONTIMEZONE, DBTIMEZONE, TZ_OFFSET(SESSIONTIMEZONE)

Unfortunatly these values always retrieved the same value, independently on the User.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!