Time Zone for a Data Source

You can define a time zone for a data source to handle the time difference between the BI Gateway Server and the database that the external data source system is referencing.

The BI Gateway server converts the extracted timestamp data to Coordinated Universal Time (UTC) along with the offset time of the data source.

The BI Gateway server uses UTC for all run time executions.

A dimension containing fields of DateTime data type is also stored in UTC along with the data source offset and the local time of the BI Gateway server. This means that for each DateTime or DateTime2 field in the dimension, the dimension table has separate columns to store data for UTC <TimeFieldName_UTC>, offset time <TimeFieldName_Offset>, and local time of the BI Gateway server <TimeFieldName>.

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 local time of the BI Gateway server.

For example, a measure has the following fields:

• "aaValuePeriodStartTime"

• "aaValuePeriodStartTime_UTC"

• "aaValuePeriodStartTime_Offset"

• "aaValuePeriodEndTime"

• "aaValuePeriodEndTime_UTC"

• "aaValuePeriodEndTime_Offset"