User Time-Zone in BI Publisher Excel Template
SummaryUser Time-Zone Management in Bi Publisher
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.