Updating report time zones

During the installation, you were prompted for the time zone of the local host, which is the time zone used in the dates and times displayed in reports. To change the time zone used in reports, use the following procedure to update the ANA_TIMEZONE_INFO-table and to reinitialize the ANA_TZ_DSTTIME table.

The reports for these applications display data in the GMT time zone only.

To update the report time zone

1. Log on to the database that is being used as the connection for the universe or the source database from the SQL prompt.
   Use an account that has write privileges to the ANA_TIMEZONE_INFO table.

2. Execute the following commands, where <REGION> is a code from the "Region" column in Time-zone-support:

   Update ANA_TIMEZONE_INFO
   Set REGION_FLAG=''
   Where REGION_FLAG= 'Y';
   
   Update ANA_TIMEZONE_INFO
   Set REGION_FLAG='Y'
   Where REGION = <REGION>;
   
   Commit;

3. Run the following procedure to reinitialize the ANA_TZ_DSTTIME table:

   execute [dbo].ANA_POPULATE_TIMEZONE_DST
   
4. Refresh the reports.