OBIEE 11g: Invalid System Time In Dashboard Footer During Export (Doc ID 2001828.1)

Last updated on MARCH 08, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.140715 to 11.1.1.7.150120 [Release 11g]
Information in this document applies to any platform.

Symptoms

Users are trying to get a correct results when exporting to PDF and Excel a dashboard page that has a Footer set. User is using the system.currentTime in their report (narrative views), this report is added to a dashboard page that has Footer option enabled.

While exporting the dashboard page to PDF/Excel, the time displayed in the report is in EST timezone and it is matching My Account preferences for the user, but the time displayed in dashboard footer in same export is in GMT timezone.
HTML export shows correct values.

The issue can be reproduced at will with the following steps:

1. Create an analysis and add any column in the criteria.
2. In the results tab add a narrative view with the text @{system.currentTime}. Specify rows to display as 1
3. Save this analysis and add it in a dashboard page.
4. Edit the dashboard page and under Print Options, enable "Include Footer" checkbox
5. Edit the footer and add the same text @{system.currentTime} and select the checkbox "Display in browser when applicable" and save the dashboard
6. In My Account properties, set the timezone as Eastern Standard Time
7. Execute the dashboard and note down the time displayed in the analysis and in the dashboard footer
8. Export the dashboard page to PDF/Excel and check if the timezones are different in the export output.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms