• Post category:BI Publisher
  • Post comments:0 Comments
  • Post last modified:February 23, 2021
  • Reading time:3 mins read
You are currently viewing How to Resolve issues with User-Level Report Timezone on BI Report?
How to Resolve issues with User-Level Report Timezone on BI Report?

In this article we will look into how to resolve the issue with User Level timezone with the output showing a day less than the actual date.

We have a setting at the BI Administration level for Report Timezone and it’s initial default value is set to User which means the individual user timezone preferences will take preference over the server timezone.

This Info can be seen under BI > Administration > Manage BI Publisher > Properties (Runtime Configuration)

image 68 1024x428 - How to Resolve issues with User-Level Report Timezone on BI Report?

Default: User

Description: Valid values: User or JVM.

When set to User, BI Publisher uses the User-level Report Time Zone setting for reports. The User Report Time Zone is set in the user’s Account Settings.

When set to JVM, BI Publisher uses the server JVM timezone setting for all users’ reports. All reports therefore display the same time regardless of individual user settings. This setting can be overridden at the report level.

With this setting of “User” at server level, if you are facing an issue with report output showing a day prior, then you try setting the individual report properties to set the report timezone of JVM and it will resolve the issue. The difference in day is due to the timezone difference between the server and the user timezones. To resolve this we are going to make the report run in the server timezone.

Navigate to Report Properties > Formatting Tab, search for “Report Timezone” setting

image 81 1024x258 - How to Resolve issues with User-Level Report Timezone on BI Report?
image 82 - How to Resolve issues with User-Level Report Timezone on BI Report?

Set the Timezone to JVM and click OK.

Save the report.

Now you should see all datetimes in server timezone and the dates would appear correctly on the output.