Run-time measures

The run-time measures are refreshed hourly at 25 minutes past the hour. The measures look for data in the last 8 hours (update interval) based on the last_edit_at column of the core table being retrieved.

• MESRDBHourlyProduction

  Calculates the total good quantity, total reject quantity, entity production rate, and entity batch size for each hour by shift, entity, and job. It is dependent on the shift history, job context, and equipment detail dimensions. This measure assumes that a job's production rate and batch size are not changing over time. If they are, this measure calculates the average for the hour.

  This measure uses a different query from the MESRDBItemProduction dimension to return the production rate and batch size information.

• MESRDBHourlyUtilization

  Calculates the total entity run time, downtime, and idletime for each hour. It is dependent on the shift history and equipment detail dimensions.

  This measure uses a different query from the MESRDBUtilization dimension to account for shift times not occurring on the hour.

  Events with a duration longer than 15 days will not be processed.

• MESRDBProduction

  Calculates the entity production quantity for each hour by shift, line, entity, job, item, and item reason. It is dependent on the item, item reason, line equipment, shift history, job context, and equipment detail dimensions.

  This measure uses the same query as the MESRDBHourlyProduction measure.