nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

User Time-Zone in BI Publisher Excel Template

Alberto Romani-Oracle

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.

Then I reviewed if there was the possibility to work on the layout. The only suggestion that I received was applicable on RTF and XPT. I should have used the following formula:

<?format-date:STARTDATETIME;'SHORT_TIME_TZ'?>

Does anyone have a suggestion on what I could apply to solve my issue when producing an Excel Template layout?

Regards

Alberto

Version

20A (11.13.20.01.0)

Find more posts tagged with

BI Publisher Data Models

Customizing Reports

Report Layouts

Customizing Layout

BI Publisher Report Templates

Comments

FPonte

Hi Alberto.

This is always tricky to setup.

I used this kind of report to check the proper configuration that worked for my users. You my try on your setup.

Also check the DM column configuration and play with User Preferences.

I think you need to logoff and logon again for each time you change the User Preferences.

Hope this help.

Cheers

Fernando

FPonte

I'm in NZ so I change my Timezone to Sydney.

The first image is the result I got.

Robert Fighiroae-Oracle

Hi Alberto,

Currently, this can be achieved via RFT or XPT templates; guide: Fusion BI Publisher - Time Zones Display - Best Practices of Coding (Doc ID 2256176.1)

Excel cannot recognize canonical date format. If the date format in the XML data is in canonical format, that is, YYYY-MM-DDThh:mm:ss+HH:MM, you must apply EXCEL functions, calculations and formats to display it properly (e.g. REPLACE, SUBSTR).

Please check the example from the documentation: 6.5 Formatting Dates -> "Formatting a Canonical Date in Excel"

https://docs.oracle.com/middleware/11119/bip/BIPRD/create_excel_tmpl.htm#CHDJAJCA

Best regards,

Robert