Resource Performance DWH#

Description#

• This report provides information about how each resource performs over a period of time.

Data Source#

• DWH Database

Assumptions#

• Calendar Days must have been generated for the Calendars of the relevant Areas.
• Each state of the Resource that wants to be reported via SEMI E10 has an attribute called "SEMI E10" that contains the SEMI E10 mapped state:
  • Engineering
  • Productive (Mandatory to be mapped for this report)
  • Standby
  • UnscheduledDown (Mandatory to be mapped for this report)
  • ScheduledDown
  • NonScheduled

Filters#

• Facility - Multi value filter on facilities
• Area - Multi value filter on Areas (restricted by the Facility filter)
• Shift - Multi value filter on Shifts (restricted by Area)
• Resource Type - Multi value filter on Resource Types
• Model - Multi value filter on Resource Model
• Processing Type - Multi value filter on Processing Types
• Resource - Multi value filter on Resources (restricted by Facility, Area, Resource Type and Model)
• Expand All Items - true or false
• Date Start - defines the start time threshold filter for material's track-in date and time at a step (date in DWH is set based on the end time of the material's operation which moved the material into the resource)
• Date End - defines the end time threshold filter for material's track-in date and time at a step (date in DWH is set based on the end time of the material's operation which moved the material into the resource)

Fields#

• Resource Facility
• Resource Area
• Resource Name
• Resource.Uptime (h) - Duration in hours when the resource System State property is Up in the reporting period for the Resource.
• Resource.Downtime (h) - Duration in hours when the resource System state property is Down in the reporting period for the Resource.
• Resource.Uptime (%) - 100% x Total time the resource SystemState is Up in the reporting period divided by the total time of the reporting period.
• Resource.Downtime (%) - 100% x Total time the resource System State is Down in the reporting period divided by the total time of the reporting period.
• Resource.MTBF (h) - Medium Time Between Failures is calculated as [Time Up at Period] / [Number of Failures] in hours. The number of failures is calculated as the number of events where the old state attribute SEMI E10 was different from Unscheduled Down (refer to the assumptions section) and the new state attribute SEMI E10 equals to Unscheduled Down.
• Resource.MTTR (h) - Medium Time To Repair is calculated as [Unscheduled Downtime at Period] / [Number of Repairs] in hours. The number of repairs is calculated as the number of events where the old state attribute SEMI E10 was equal to Unscheduled Down refer to the assumptions section) and the new state SEMI E10 was different from Unscheduled Down.
• Resource.ProductionPPH - Production Pieces Per Hour is the number of primary units processed (given by the TrackInQuantity at TrackOut) divided by the number of hours in the period when the resource was with in a state with the attribute SEMI E10 equal to Productive (Refer to the assumptions section), for tracked-out Material during the period.
• Resource.GlobalPPH - Global Units Per Hour is the number of primary units processed (given by the TrackInQuantity at TrackOut) divided by the number of hours in the period, for tracked-out Material during the period.
• Resource.Yield - 100 x TrackOutQuantity / TrackInQuantity for tracked out Material during the period (primary quantity only)

Example#