Understand configuration dimensions

Refreshing of the Configuration Dimensions

The configuration dimensions are refreshed every 8 hours or daily at 15 minutes past midnight. These dimensions look for data changes from the start of the deployment.

The default refresh rate settings are set with the expectation that configuration data is relatively static over time. With these settings, new records added to these configuration dimensions will not appear in reports for at least 8 or 24 hours depending on the setting. The dimensions set with an 8‑hour refresh are the ones to which the measure definitions refer. This is done because the measures are configured to recalculate only the last 8 hours of data, which means any dependent dimensions must be updated within that time window to reflect changes.

Additionally, BI Gateway will create a new record and mark the old record obsolete when a change is detected in non-time-defining dimensions. The impact of this is that a change in the name or other fields of a record will only be reflected on new dependent data coming into the system with the older records still referencing the original values. Redeploying the model will correct this, but will delete existing data and restart the extraction process.

Configuration Dimensions List: 8‑Hour Refresh

• MESRDBEquipmentDetail

  Contains the MES entity (equipment) definitions. It includes all entities and their associated capability configuration data from the OEE, Utilization, and Storage Executor tables (OEE_Exec, Util_Exec, and Storage_Exec).

• MESRDBItem

  Contains the item (product) definitions. It also includes item display setting, item class, unit of measure, and unit of measure conversion data.

• MESRDBItemReason

  Contains the production (item) reason, grade, and state definitions.

• MESRDBLineEquipment

  Contains the MES Performance line and line entity (equipment) definitions.

Configuration Dimensions List: Daily Refresh

• MESRDBCause

  Contains the MES Quality cause definitions.

• MESRDBCharacteristic

  Contains the MES Quality characteristic definitions.

• MESRDBItemCategory

  Contains the item category definitions for MES Quality.

• MESRDBOperation

  Contains the MES Operations process and operations definitions.

• MESRDBQMSpec

  Contains the MES Quality QM Specification and associated characteristic definitions.

• MESRDBReasonGroup

  Contains the MES Performance reason group definitions and hierarchy.

• MESRDBReasons

  Contains the MES Performance reason definitions. It includes the reason group and utilization state to which the reason is linked.

• MESRDBSampleFreq

  Contains the MES Quality sample frequency definitions.

• MESRDBShift

  Contains the shift definitions.

• MESRDBSystemAttr

  Contains the general system attribute (parameter) definitions.

• MESRDBUOM

  Contains the unit of measure and conversion definitions.

• MESRDBUser

  Contains the MES user definitions.

• MESRDBUtilCategory

  Contains the MES Performance utilization reason category definitions from the possible set of categories defined for all reasons.

• MESRDBUtilState

  Contains the MES Performance utilization state definitions.

• MESRDBVersion

  Contains the MES database version, MES model version, and MES SSRS report version information.