Source information

The Technician Performance model consists of two main fact tables: one holds data of reported operations and reported hours and the other employee work hours. The employee work hours are used to calculate unreported hours.

Reported operations and hours are based on the M3 BE table MMOPTR, and the data in the table corresponds to M3 programs MOS100 related option 16 or MOS070. The transaction date for when the job was performed is linked to the Time dimension.

Employee work hours are sourced from M3 BE table MCPAPD, which is populated by M3 program CPS170 and CPS160. The Time dimension is linked to the calendar date. Measures and calculations that are based on this table can only be analyzed by using the Technician, Time, and Time Intelligence dimensions.

The First Time Fix Operation measure is based on the service error report, M3 BE table MMOSER.

These measures should not be used with the Costing Type dimension: No of Rptd Operations, First Time Fix Operations, and First Time Fix Rate. These are only counted for each operation of a work order.

The No. of Work Orders measure is from Equipment Reliability and may not be used with the Costing Type and Technician dimensions.

Since the Facility dimension is linked to the facility of the transaction and the Technician dimension is based on the organizational hierarchy of the technician, the facility - technician filter interdependence has not been implemented.

Widgets with Technician as the main dimension can be filtered by widgets from Labor Resource Analysis having Labor Work Center as the main dimension.