Time zone for a data source

Time zone for AVEVA Insight

The time zone for the AVEVA Insight data adapter is always represented using (UTC) Coordinated Universal Time.

Time zone for Microsoft Azure SQL Database

You can define a time zone for a data source to handle the time difference between the BI Gateway application and the database that the external data source system is referencing. By default, the time zone for the Microsoft Azure SQL Database data adapter is represented using (UTC) Coordinated Universal Time. However, you can edit the time zone if required.

For example, a dimension named "DimensionShift" that has DateTime fields defined as "ShiftStartTime" and "ShiftEndTime" has the following columns:

• ShiftStartTime

• ShiftStartTime_UTC

• ShiftStartTime_Offset

• ShiftEndTime

• ShiftEndTime_UTC

• ShiftEndTime_Offset

The measure table stores the measure calculation period start and end time in UTC, offset time, and the time of the external data source system database.

For example, a measure has the following fields:

• "aaValuePeriodStartTime"

• "aaValuePeriodStartTime_UTC"

• "aaValuePeriodStartTime_Offset"

• "aaValuePeriodEndTime"

• "aaValuePeriodEndTime_UTC"

• "aaValuePeriodEndTime_Offset"