Refresh and Update Intervals

All the configuration dimensions are independent definitions that are expected to remain static over long periods of time. As such, these dimensions are configured for a refresh interval of every 8 hours or every 24 hours with an offset of 15 minutes, depending on the dimension. This means that these dimensions are updated at least every day at 12:15 AM.

The run-time dimensions are the key dimensions that extract the data from the MES database for the reporting content. Except for the shift history dimension, which runs every 30 minutes, these are configured for a refresh interval of every hour by default. Based on their dependencies, these dimensions have an offset from the dependent dimensions to ensure the dependent dimensions are updated first. The offsets are set at 17 or 20 minutes based on the dependencies.

The run-time dimensions have an update interval of either 1 or 2 days depending on the dimension. This means that only new or changed records from the most recent 1 or 2 days are being retrieved.

The run-time measures further calculate aggregate data with additional data grouping. Since these measures require all the other dimensions to be updated first, they are configured for a refresh interval of every hour by default and an offset of 25 minutes.

The measures are configured for an update interval of 8 hours, which is used to update existing hourly buckets within the last 8 hours when a record is modified. For example, if an historical utilization event is split or modified to change its utilization state, this change will be reflected in the BI Gateway database as long as the modification was made to a record within the last 8 hours. Also, depending on your offset from UTC, the modifications will not appear in BI Gateway for the number of hours your timezone is offset from UTC for those locations that have a negative offset from UTC.