Run-time dimensions

The run-time dimensions are refreshed hourly (except where noted) and retrieve new and modified data from the MES database. These dimensions look for data in the last 2 days (update interval) based on the last_edit_at column in the corresponding MES database table. The utilization, job, and job context dimensions look for data in the last 1 day instead of 2 days.

• MESRDBItemConsumption

  Contains the MES Operations consumption transaction records. It is dependent on the Item dimension and has a 20-minute offset.

• MESRDBItemProduction

  Contains the job production transaction records. It also contains the item grade, item state, and entity information from those tables. It is dependent on the job, shift, item reason, and item dimensions and has a 20-minute offset.

• MESRDBJob

  Contains the job records from the Job table. It has no dependencies and a 17-minute offset. This dimension is configured as a Time-Defining Dimension. This means that existing records will be overwritten if the value changes between updates (as opposed to creating a new record and marking the original record as obsolete).

• MESRDBJobContext

  Contains the metadata that describes a job record (work order, operation, and sequence number) and its start time. This dimension is referenced by the measures instead of the Job dimension as the job context records should not change after their initial retrieval. It has no dependencies and has a 17-minute offset.

• MESRDBLot

  Contains the metadata that fully describes a lot and sublot. It has no dependencies and has a 15-minute offset.

• MESRDBResourceActual

  Contains the job events records. It has no dependencies and has a 15-minute offset.

• MESRDBSampleCharRuleLink

  Contains the MES Quality control rule violations recorded for a characteristic in a sample. It has no dependencies and has a 15-minute offset.

• MESRDBSampleResults

  Contains the MES Quality sample results recorded for each characteristic in a sample. It also includes the process name from the Wo table and the entity name from the Entity table. It is dependent on the QM Specification, characteristic, sample frequency, and cause dimensions and has a 20-minute offset.

• MESRDBShiftHistory

  Contains the shift history records for each entity. It also calculates the Production Day value based on the system attribute setting (see Specifying the Production Day). It has no dependencies and a 15-minute offset. This dimension is configured as a Time-Defining Dimension. This means that existing records will be overwritten if the value changes between updates (as opposed to creating a new record and marking the original record as obsolete). It is also configured for a 30-minute refresh rate to more quickly capture shift changes in time zones with a 30-minute offset.

• MESRDBUtilization

  Contains the utilization records for each entity. It includes the job, item, entity, line, and KPI target values from the corresponding tables. It is dependent on the job, shift history, line equipment, item, and reason dimensions and has a 20-minute offset.

• MESRDBWorkOrder

  Contains the metadata that fully describes a work order record. It has no dependencies and has a 15-minute offset.