Resource Cube#

This cube collects information regarding Resource availability and overall performance.

Dimensions#

This section describes the dimensions of the Resource Cube.

• Area - Contains all areas available in the system during the cube processing. Since areas can be hierarchical, both parent and child areas can be selected as separate dimension keys.

• Date - Contains all calendar days used in the system.

• Employee - Contains all employees available in the system during the cube processing.

• Facility - Contains all facilities available in the system during the cube processing.

• Fiscal Date - This is a representation of the day that has shifts. Instead of grouping facts between 00:00:00 and 23:59:59 like in the Date dimension, it uses the beginning of the first shift and the end of the last shift for grouping. Use this dimension combined with the Shift dimension to select individual shifts.

• Material Hierarchy - This dimension allows the filtering of the materials according to their hierarchy. This filter is associated with measures within the Resource Material Processed and Resource Material Loss and Bonus measure groups. The available options are:

  • Topmost Material - Materials without a parent material.
  • Inner Material - Materials with a parent material and sub-materials.
  • Leaf Material - Materials with a parent material and without any sub-materials.

• Operation - Contains all operations defined on the system during the cube processing.

• Parent Resource - Contains the parent resource, if existing, for all resources available in the system during the cube processing.

  Note

  This dimension is only computed when the Resource has a single parent.

• Resource - Contains all resources defined on the system during the cube processing.

• Resource State Model - This dimensions allow the selection and filtering of information using the pre-configured SEMI-E10 or any user defined state model.

• Resource State Model Change Reason - The reason for the current state model state.

• Service - Contains all the services defined on the system during the cube processing.

• Shift - Contains all shifts defined on the system during the cube processing.

• Shift Date - Contains all fiscal dates defined on the system during the cube processing.

• Step - Contains all steps defined on the system during the cube processing.

• Team - Contains all teams defined on the system during the cube processing.

• Time - The day time representation. All the seconds of the day are available (max: 235959).

• Timezone - The timezone representation.

Measure Groups#

There are four measure groups in the Resource Cube:

• Resource
• Resource Material Loss and Bonus
• Resource Material Processed
• Resource Reference Production Quantities

Resource#

• SEMI-E10 Down Time - Calculated as [Scheduled Down Time] + [Unscheduled Down Time]

• SEMI-E10 Manufacturing Time - Calculated as [Productive Time] + [Stand By Time]

• SEMI-E10 Operations Time - Calculated as [Engineering Time] + [Productive Time] + [Standby Time] + [Scheduled Down Time]

• SEMI-E10 Total Time - Calculated as [Engineering Time] + [Productive Time] + [Standby Time] + [Scheduled Down Time] + [Unscheduled Down Time] + [Non Scheduled Time]

• SEMI-E10 Up Time - Calculated as [Engineering Time] + [Productive Time] + [Standby Time]

• Engineering Time - Amount of time (in seconds) a resource remained in the Engineering SEMI-E10 state

• Non Scheduled Time - Amount of time (in seconds) a resource remained in the Non Scheduled SEMI-E10 state

• Productive Time - Amount of time (in seconds) a resource remained in the Productive SEMI-E10 state

• Scheduled Down Time - Amount of time (in seconds) a resource remained in the Scheduled Down SEMI-E10 state

• Stand By Time - Amount of time (in seconds) a resource remained in the Standby SEMI-E10 state

• Unscheduled Down Time - Amount of time (in seconds) a resource remained the in Unscheduled Down SEMI-E10 state

• Down Duration for Transitions - Depending on the state model (SEMI-E10 or other), this value represents the amount of time (in seconds) a resource was in the Unscheduled Down SEMI-E10 state (SEMI-E10) or Down Time state (other)

• Down Time - Amount of time (in seconds) the resource was down

• Down Time (%) - Calculated as ([Measures].[Down Time] / ([Measures].[Up Time] + [Measures].[Down Time]))

• Down To Up Transitions - Number of transitions from Down to Up State. See [Measure].[Down Duration for Transitions] and [Measure].[Up Duration for Transitions] to understand how Down and Up states are accounted

• MTBF - Medium Time Between Failures - This is calculated based on the following formula: [Measures].[Up Duration For Transitions]/[Measures].[Up To Down Transitions]

• MTTR - Medium Time To Repair - This is calculated based on the following formula: [Measures].[Down Duration For Transitions]/[Measures].[Down To Up Transitions]

• Total Available Time - Calculated as Up Time + Downtime as retrieved from basic state model

• Total Time - This is calculated as [Up Time] + [Down Time] + [Non Scheduled Time] duration in seconds

• Up Duration for Transitions - Depending on the state model (SEMI-E10 or other), this value represents the amount of time (in seconds) a resource was not in the Unscheduled Down SEMI-E10 state (SEMI-E10) or was in the Up Time state (other)

• Up Time - The duration in seconds, for which a resource was up

• Up Time (%) - Calculated as ([Measures].[Up Time] / ([Measures].[Up Time] + [Measures].[Down Time]))

• Up To Down Transitions - Number of transitions from Up to Down State. See [Measure].[Down Duration for Transitions] and [Measure].[Up Duration for Transitions] to understand how Down and Up states are accounted

• UPH - Units Per Hour - Calculated as ([Measures].[Total Primary Processed Quantity Normalized] + [Total Primary Quantity Bonus Normalized] ) / [Equipment Production Scheduled Time] / 60 / 60

• Equipment Operational Up Time - Calculated as [Engineering Time] + [Productive Time] + [Standby Time]

• Equipment Production Scheduled Time - Calculated as [Engineering Time] + [Productive Time] + [Standby Time] + [Unscheduled Down Time]

• Equipment Productive Time - Calculated as [Engineering Time] + [Productive Time]

• OEE% - Overall Equipment Effectiveness - Calculated as ( [Measures].[Up Time (%)] [Measures].[Performance Efficiency (%)] [Measures].[Rate of Quality (%)] ) / 10000

• Operation Efficiency (%) - Calculated as [Productive Time] / [Equipment Operational Uptime]

• Performance Efficiency (%) - Calculated as [Rate Efficiency (%)] * [Operational Efficiency (%)]

• Rate of Efficiency (%) - Calculated as ([Measures].[Total Primary Processed Quantity Normalized] + [Measures].[Total Primary Quantity In-Process Loss Normalized] + [Measures].[Total Sub Resources Primary Quantity In-Process Loss Normalized]) / [Measures].[Reference Quantity]

• Rate of Quality (%) - Calculated as ([Measures].[Total Primary Processed Quantity Normalized] - [Measures].[Total Primary Quantity Processed Loss Normalized] - [Measures].[Total Primary Quantity Out Of Step Loss Normalized] - [Measures].[Total Sub Resources Primary Quantity Processed Loss Normalized] - [Measures].[Total Sub Resources Primary Quantity Out Of Step Loss Normalized]) / ([Measures].[Total Primary Processed Quantity Normalized] + [Measures].[Total Primary Quantity In-Process Loss Normalized] + [Measures].[Total Sub Resources Primary Quantity In-Process Loss Normalized])

Resource Material Loss and Bonus#

This section describes the Resource Material Loss and Bonus Measure Group.

• Materials Primary Quantity Bonus - The primary bonus quantity of material. This is an approximation as one must accommodate track in / track out periods to shifts and also due to the parallel material processing of a resource. This should only be used for OEE calculation.

• Materials Primary Quantity Loss - Same as above.

• Materials Secondary Quantity Bonus - Same as above.

• Materials Secondary Quantity Loss - Same as above.

• Sub Resources Material Primary Quantity Bonus - The primary bonus quantity of material given in sub-resources. This is an approximation as one must accommodate track in / track out periods to shifts and also due to the parallel material processing of a resource. This should only be used for OEE calculation.

• Sub Resources Material Primary Quantity Loss - The primary loss quantity of material given in sub-resources. This is an approximation as one must accommodate track in / track out periods to shifts and also due to the parallel material processing of a resource. This should only be used for OEE calculation.

• Sub Resources Material Secondary Quantity Bonus - The secondary bonus quantity of material given in sub-resources. This is an approximation as one must accommodate track in / track out periods to shifts and also due to the parallel material processing of a resource. This should only be used for OEE calculation.

• Sub Resources Material Secondary Quantity Loss - The secondary loss quantity of material given in sub-resources. This is an approximation as one must accommodate track in / track out periods to shifts and also due to the parallel material processing of a resource. This should only be used for OEE calculation.

• Total Primary Quantity Bonus Normalized - Materials Primary Quantity Bonus normalized using the ratio between the current material's ideal cycle time and the reference material ideal's cycle time. The reference material is used due to the resource processing different materials, with different cycle times. If no configuration for the Ideal Cycle time is found, this attribute will be zero.

• Total Primary Quantity In-Process Loss Normalized - The total primary quantity loss is based on the track-out quantities added to In-Process losses. Normalized using the same approach as defined above.

• Total Primary Quantity Processed Loss Normalized - The total primary quantity loss is based on the track-out quantities added to Processed losses. Normalized using the same approach as defined above.

• Total Primary Quantity Out Of Step Loss Normalized - The total primary quantity loss is based on the track-out quantities added to losses registered out of Step. Normalized using the same approach as defined above.

  Note

  Calculation of OEE quantities is based on Processed quantities instead of Tracked in quantities. This is particularly important for manufacturing processes that start with a Material having zero as Primary Quantity which is then added by using the Assemble operation.

• Total Sub Resources Primary Quantity In-Process Loss Normalized - The total primary loss quantity of material given in sub-resources. The total primary quantity loss is based on the track-out quantities added to In-Process losses. Normalized using the same approach as defined above.

• Total Sub Resources Primary Quantity Processed Loss Normalized - The total primary loss quantity of material given in sub-resources. The total primary quantity loss is based on the track-out quantities added to Processed losses. Normalized using the same approach as defined above.

• Total Sub Resources Primary Quantity Out Of Step Loss Normalized - The total primary loss quantity of material given in sub-resources. The total primary quantity loss is based on the track-out quantities added to losses registered out of Step. Normalized using the same approach as defined above.

  Note

  For Sub-Resources with Sub-Material tracking, a specific handling is implemented to cope with the possibility that Sub-Materials can be tracked out before the parent Material, in which case losses should be counted as In-Process losses rather than Processed losses.

• Total Primary Quantity Loss Normalized - Normalized using the same approach as above.

• Total Sub Resources Primary Quantity Bonus Normalized - Materials Primary Quantity Bonus normalized using the ratio between the current material's ideal cycle time and the reference material ideal's cycle time. The reference material is used due to the resource processing different materials, with different cycle times. If no configuration for the Ideal Cycle time is found, this attribute will be zero. This measure considers only materials processed at sub-resources.

• Total Sub Resources Primary Quantity Loss Normalized - Normalized using the same approach as above.

Resource Material Processed#

This section describes the Resource Material Processed Measure Group.

• Input Primary Quantity - Material Primary Quantity tracked in to the resource. This is an approximation as one must accommodate track in / track out periods to shifts and also due to the parallel material processing of a resource.

• Input Sub Materials Primary Quantity - Same as above.

• Primary Input Quantity Normalized - Normalization of the Input Primary Quantity. This measure is normalized using the ratio between the current material's ideal cycle time and the reference material ideal's cycle time. The reference is according to the settings configured in the Resource Ideal Cycle Time Smart Table (refer to Resource Reference Production Quantities). The reference material is used due to the resource processing different materials, with different cycle times. If no configuration for the Ideal Cycle time is found, this attribute will be zero.

• Primary Processed Quantity Normalized - Normalization of the Processed Primary Quantity. This measure is normalized using the ratio between the current material's ideal cycle time and the reference material ideal's cycle time. The reference is according to the settings configured in the Resource Ideal Cycle Time Smart Table (refer to Resource Reference Production Quantities). The reference material is used due to the resource processing different materials, with different cycle times. If no configuration for the Ideal Cycle time is found, this attribute will be zero.

• Processed Primary Quantity - Material Primary Quantity tracked out from the resource. This is an approximation as one must accommodate track in / track out periods to shifts and also due to the parallel material processing of a resource.

• Processed Secondary Quantity - Same as above.

• Processed Sub Materials Primary Quantity - Same as above.

• Processed Sub Materials Secondary Quantity - Same as above.

• Total Primary Processed Quantity Normalized - Calculated as [Processed Primary Quantity] + [Processed Sub Materials Primary Quantity]. This result is normalized using the ratio between the current material's ideal cycle time and the reference material ideal's cycle time. The reference is according to the settings configured in the Resource Ideal Cycle Time Smart Table (refer to Resource Reference Production Quantities). The reference material is used due to the resource processing different materials, with different cycle times. If no configuration for the Ideal Cycle time is found, this attribute will be zero.

Resource Reference Production Quantities#

This section describes the Resource Reference Production Quantities Measure Group. These measures reflect the configuration set for the Resource Ideal Cycle time (is reference=true rows) at the time of data aggregation.

This configuration is used for Online Equipment Efficiency (OEE) calculations. Produced quantities are normalized using the matching Reference Product unit cycle time. This enables distinct products with different unit cycle times to be used in the calculation of a meaningful OEE indicator.

• Reference Cycle Time - This is the ideal time per unit for the Reference Product. This Measure is based on the Cycle Time configuration for the resource. If this configuration is absent, the value is null. If the Resource Reference Quantity Count is higher than 1, meaning that N facts are being selected by the query on each row, the value represents the maximum value.

• Reference Quantity - This is the Ideal Quantity the resource should process in the period (using the Reference Product). This Measure is based on the Cycle Time configuration for the resource. If this configuration is absent, the value is zero. If the Resource Reference Quantity Count is higher than 1, meaning that N facts are being selected by the query on each row, this value is summed up.

• Resource Reference Quantity Count - The number of occurrences found.

Dimensions and Measure Groups#

Table: Resource Cube - Dimensions and Measure Groups