Material Cube#
This cube collects information regarding Material events, Material step movements, Material quality and Material attributes.
Dimensions#
This section describes the dimensions of the Material cube.
Affected Material - Contains the affected Materials.
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.
Bonus Reason - Contains all reasons available in the system during the cube processing. This column is directly linked to the Bonus columns on fact tables.
Date - Contains all calendar days available in the system during the cube processing.
Dispatched Date - Contains all dispatch dates available in the system during the cube processing.
Dispatched Employee - Contains all Employees available in the system during the cube processing. This column is directly linked to Dispatched columns on fact tables.
Dispatched Shift - Contains all Shift available in the system during the cube processing. This column is directly linked to Dispatched columns on fact tables.
Dispatched Team - Contains all Teams available in the system during the cube processing. This column is directly linked to Dispatched columns on fact tables.
Dispatched Time - Day time representation. All seconds of the day are available (max: 235959).
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 a day that has shifts. Instead of grouping facts between 00:00:00 and 23:59:59 like in Date dimension, it uses the beginning of the first shift and the end of the last shift for grouping. Use this dimension combined with Shift dimension to isolate shifts.
Flow - Contains all Flows available in the system during the cube processing.
Flow Path - Contains all Flow Paths available in the system during the cube processing.
In Process Date - Contains all calendar days available in the system during the cube processing. This column is directly linked to In Process columns on fact tables.
In Process Employee - Contains all Employees available in the system during the cube processing. This column is directly linked to In Process columns on fact tables.
In Process Shift - Contains all Shift available in the system during the cube processing. This column is directly linked to In Process columns on fact tables.
In Process Team - Contains all Teams available in the system during the cube processing. This column is directly linked to In Process columns on fact tables.
In Process Time - Day time representation. All seconds of the day are available (max: 235959). This column is directly linked to In Process columns on fact tables.
Loss Reason - Contains all reasons available in the system during the cube processing. This column is directly linked to Loss columns on fact tables.
Material - Contains all Materials available in the system during the cube processing.
Material Attribute - Contains all Attributes that can be found for any material occurrence.
Material Attribute Index - Contains the position of the attribute value within the attribute index (useful to match attribute names and values).
Material Attribute Value - Contains all attribute values that can be found for any material occurrence.
Material Defect - Contains all Material Defects available in the system during the cube processing.
Material Defect System State - Contains all system states of the Material Defects available in the system during the cube processing.
Material Hierarchy - Contains all Material Hierarchies available in the system during the cube processing.
Material State - Possible values are: Queued, Dispatched, In Process, Processed, In Transit, and Consumable.
Off Flow Type - Contains all Off-Flow types available in the system during the cube processing.
Operation - Contains all operations available in the system during the cube processing.
Parent Material - Contains all parent materials available in the system during the cube processing.
Processed Date - Contains all calendar days available in the system during the cube processing. This column is directly linked to Processed columns on fact tables.
Processed Employee - Contains all Employees available in the system during the cube processing. This column is directly linked to Processed columns on fact tables.
Processed Resource - Contains all Resources available in the system during the cube processing. This column is directly linked to Processed columns on fact tables.
Processed Shift - Contains all Shift available in the system during the cube processing. This column is directly linked to Processed columns on fact tables.
Processed Team - Contains all Teams available in the system during the cube processing. This column is directly linked to Processed columns on fact tables.
Processed Time - Day time representation. All seconds of the day are available (max: 235959). This column is directly linked to Processed columns on fact tables.
Processed TopMostResource - Contains all Top Most Resources available in the system during the cube processing. This column is directly linked to Processed columns on fact tables.
Product - Contains all Products available in the system during the cube processing.
Product Group - Contains all Products groups available in the system during the cube processing.
Production Order - Contains all Production orders available in the system during the cube processing.
Quality Reason - Contains all reasons for events of type loss, bonus and hold of material.
Queued Date - Contains all calendar days available in the system during the cube processing. This column is directly linked to Queued columns on fact tables.
Queued Employee - Contains all Employees available in the system during the cube processing. This column is directly linked to Queued columns on fact tables.
Queued Shift - Contains all Shifts available in the system during the cube processing. This column is directly linked to Queued columns on fact tables.
Queued Team - Contains all Teams available in the system during the cube processing. This column is directly linked to Queued columns on fact tables.
Queued Time - Day time representation. All seconds of the day are available (max: 235959). This column is directly linked to Queued columns on fact tables.
Reason - Contains all Reasons available in the system during the cube processing.
Related Material - Some operations, like "Split" for instance, can originate several new materials. The relation between the source material and the target materials are maintained in the relational database, and this dimension presents all source materials that were affected by such an operation.
Related Product - All Products affected by the operation.
Release from Hold Date - Date when the Release operation took place.
Release from Hold Fiscal Date - Fiscal Date when Release operation took place.
Release from Hold Time - Time when the hold was released.
Release Shift - Shift when the hold was released.
Resource - Contains all Resources available in the system during the cube processing.
Rework Reason - Contains all reasons for events of type Rework.
Service - Contains all Services available in the system during the cube processing.
Shift - Contains all shifts available in the system during the cube processing.
Step - Contains all steps available in the system during the cube processing.
Step Output Date - Date when the last operation over the material occurred on the step. Fact table will only have this information when either the material is terminated or the material leaves the step.
Step Output Employee - Employee that recorded the last operation over the material on the step. Fact table will only have this information when either the material is terminated or the material leaves the step.
Step Output Shift - Shift when the last operation over the material occurred on the step. Fact table will only have this information when either the material is terminated or the material leaves the step.
Step Output Team - Team working in the shift when the last operation over the material occurred on the step. Fact table will only have this information when either the material is terminated or the material leaves the step.
Step Output Time - Time when the last operation over the material occurred on the step. Fact table will only have this information when either the material is terminated or the material leaves the step.
Team - Contains all teams available in the system during the cube processing.
Time - Day time representation. All seconds of the day are available (max: 235959).
Timezone - Timezone representation.
Top Most Flow Path - Contains all Top Most Flow Paths available in the system during the cube processing.
Unit - Primary - The unit of measurement that represents the Primary Quantity.
Unit - Secondary - The unit of measurement that represents the Secondary Quantity.
Measure Groups#
There are five measure groups in the Material cube:
- Material
- Material Attribute
- Material Movement
- Material Quality
- Resource Material Loss Bonus
Material#
This section describes the Material Measure Group.
This Measure group is useful to count the number of Operations, Volume or Cost for a specific material, or group of materials, during a time interval. You can also filter by a group of Steps.
-
Material Count - Number of Material events
-
Maximum Datetime - Maximum Datetime for the event(s)
-
Maximum Material Cost - Maximum Material Cost for the event(s)
-
Maximum Sub Materials Cost - Maximum Sub Materials Cost for the event(s)
-
Minimum Datetime - Minimum Datetime for the event(s)
-
Minimum Material Cost - Minimum Material Cost for the event(s)
-
Minimum Sub Materials Cost - Minimum Sub Materials Cost for the event(s)
-
Material Primary Quantity - Material Primary quantity for the event(s)
-
Material Secondary Quantity - Material Secondary for the event(s)
-
Sub Materials Primary Quantity - Sub Material Primary quantity for the event(s)
-
Sub Materials Secondary Quantity - Sub Material Secondary quantity for the event(s)
Material Attribute#
This section describes the Material Attribute Measure Group.
- Material Attribute Count - The number of Attributes
Material Movement#
This section describes the Material Movement Measure Group
The following diagram illustrates each individual quantity (Queued, Dispatched, InProcess, Processed), the moment where it is collected (Input or Output from each state) and possible Bonuses or Losses.
-
Ideal Cycle Time - The Ideal Cycle Time, for a given resource, product and step. Its calculation depends of the settings set in the smart table "Resource Ideal Cycle Time".
-
Material Cycle Time - The Material Cycle Time is the result of the following formula:
Sum((Processed Primary Output Quantity + Processed Sub Materials Primary Output Quantity) *
(Dispatched Lag + In Process Lag + Queued Lag + Processed Lag))
/ Sum(Processed Primary Output Quantity + Processed Sub Materials Primary Output Quantity)
Info
Lags are processed per step movement (by material and for each distinct "Date Entered Step" found) therefore this cycle time refers to a Step Cycle Time by material, i.e. on average how long it takes to produce 1 Material on a step
- Unit Cycle Time - The Unit Cycle Time is the result of the following formula:
Sum((Dispatched Lag + In Process Lag + Processed Lag + Queued Lag))
/
Sum((Processed Primary Output Quantity + Processed Sub Materials Primary Output
Quantity))
Info
Lags are processed per step movement (by material and for each distinct "Date Entered Step" found) therefore this cycle time refers to a Step Cycle Time by unit, i.e. on average how long it takes to produce 1 Unit on a step
-
Dispatched Primary Quantity - The primary quantity recorded when the last system state transitions from an previous state to Dispatch concerning material and step. In case there was no transition, the first operation of this system state is used
-
Dispatched Secondary Quantity - The secondary quantity recorded when the last system state transitions from an previous state to Dispatch concerning material and step. In case there was no transition, the first operation of this system state is used
-
Dispatched Sub Materials Primary Quantity - The Sub Material primary quantity recorded when the last system state transitions from an previous state to Dispatch concerning material and step. In case there was no transition, the first operation of this system state is used
-
Dispatched Sub Materials Primary Quantity Bonus - The Sub Material primary quantity bonus quantity recorded on the last operation performed for the Dispatched state
-
Dispatched Sub Materials Primary Quantity Loss - The Sub Material primary quantity loss quantity recorded on the last operation performed for the Dispatched state
-
Dispatched Sub Materials Secondary Quantity - The Sub Material secondary quantity recorded when the last system state transitions from an previous state to Dispatch concerning material and step. In case there was no transition, the first operation of this system state is used
-
Dispatched Sub Materials Primary Quantity Bonus - The Sub Material secondary quantity bonus quantity recorded on the last operation performed for the Dispatched state
-
Dispatched Sub Materials Primary Quantity Loss - The Sub Material secondary quantity loss quantity recorded on the last operation performed for the Dispatched state
-
Dispatched Primary Output Quantity - The primary quantity recorded on the last operation performed for the Dispatched state
-
Dispatched Secondary Output Quantity - The secondary quantity recorded on the last operation performed for the Dispatched state
-
Dispatched Sub Materials Primary Output Quantity - The Sub Material primary quantity recorded on the last operation performed for the Dispatched state
-
Dispatched Sub Materials Secondary Output Quantity - The Sub Material secondary quantity recorded on the last operation performed for the Dispatched state
-
Dispatched Primary Quantity Bonus - The primary quantity bonus quantity recorded on the last operation performed for the Dispatched state
-
Dispatched Primary Quantity Loss - The primary quantity loss quantity recorded on the last operation performed for the Dispatched state
-
Dispatched Secondary Quantity Bonus - The secondary quantity bonus quantity recorded on the last operation performed for the Dispatched state
-
Dispatched Secondary Quantity Loss - The secondary quantity loss quantity recorded on the last operation performed for the Dispatched state
-
In Process Primary Quantity - The primary quantity recorded when the last system state transitions from an previous state to In Process concerning material and step. In case there was no transition, the first operation of this system state is used
-
In Process Secondary Quantity - The secondary quantity recorded when the last system state transitions from an previous state to In Process concerning material and step. In case there was no transition, the first operation of this system state is used
-
In Process Sub Materials Primary Quantity - The Sub Material primary quantity recorded when the last system state transition from an previous state to In Process concerning material and step. In case there was no transition, the first operation of this system state is used
-
In Process Sub Materials Primary Quantity Bonus - The Sub Material primary quantity bonus quantity recorded on the last operation performed for the In Process state
-
In Process Sub Materials Primary Quantity Loss - The Sub Material primary quantity loss quantity recorded on the last operation performed for the In Process state
-
In Process Sub Materials Secondary Quantity - The Sub Material secondary recorded when the last system state transition from an previous state to In Process concerning material and step. In case there was no transition, the first operation of this system state is used
-
In Process Sub Materials Secondary Quantity Bonus - The Sub Material secondary quantity bonus quantity recorded on the last operation performed for the In Process state
-
In Process Sub Materials Secondary Quantity Loss - The Sub Material secondary quantity loss quantity recorded on the last operation performed for the In Process state
-
In Process Primary Output Quantity - The primary quantity recorded on the last operation performed for the In Process state
-
In Process Secondary Output Quantity - The secondary quantity recorded on the last operation performed for the In Process state
-
In Process Sub Materials Primary Output Quantity - The Sub Material primary quantity recorded on the last operation performed for the In Process state
-
In Process Sub Materials Secondary Output Quantity - The Sub Material secondary quantity recorded on the last operation performed for the In Process state
-
In Process Primary Quantity Bonus - The primary quantity bonus quantity recorded on the last operation performed for the In Process state
-
In Process Primary Quantity Loss - The primary quantity loss quantity recorded on the last operation performed for the In Process state
-
In Process Secondary Quantity Bonus - The secondary quantity bonus quantity recorded on the last operation performed for the In Process state
-
In Process Secondary Quantity Loss - The secondary quantity loss quantity recorded on the last operation performed for the In Process state
-
Dispatched Lag - The duration in seconds, from the last Dispatch state operation until it changes state (ex: transition to In Process)
-
In Process Lag - The duration in seconds, from the last Process state operation until it changes state (ex: transition to Processed)
-
Processed Lag - The duration in seconds, from the last Processed state operation until it changes state (ex: transition to In Transit)
-
Queued Lag - The duration in seconds, from the last Queued state operation until it changes state (ex: transition to Dispatch)
-
Processed Primary Quantity - The primary quantity recorded when the last system state transitions from an previous state to Processed concerning material and step. In case there was no transition, the first operation of this system state is used
-
Processed Secondary Quantity - The secondary quantity recorded when the last system state transitions from an previous state to Processed concerning material and step. In case there was no transition, the first operation of this system state is used
-
Processed Sub Materials Primary Quantity - The Sub Material primary quantity recorded when the last system state transitions from an previous state to Processed concerning material and step. In case there was no transition, the first operation of this system state is used
-
Processed Sub Materials Primary Quantity Bonus - The Sub Material primary quantity bonus quantity recorded on the last operation performed for the Processed state
-
Processed Sub Materials Primary Quantity Loss - The Sub Material primary quantity loss quantity recorded on the last operation performed for the Processed state
-
Processed Sub Materials Secondary Quantity - The Sub Material secondary quantity recorded when the last system state transitions from an previous state to Processed concerning material and step. In case there was no transition, the first operation of this system state is used
-
Processed Sub Materials Secondary Quantity Bonus - The Sub Material secondary quantity bonus quantity recorded on the last operation performed for the Processed state
-
Processed Sub Materials Secondary Quantity Loss - The Sub Material secondary quantity loss quantity recorded on the last operation performed for the Processed state
-
Processed Primary Output Quantity - The primary quantity recorded on the last operation performed for the Processed state
-
Processed Secondary Output Quantity - The secondary quantity recorded on the last operation performed for the Processed state
-
Processed Sub Materials Primary Output Quantity - The Sub Material primary quantity recorded on the last operation performed the Processed material state
-
Processed Sub Materials Secondary Output Quantity - The Sub Material secondary quantity recorded on the last operation performed the Processed material state
-
Processed Primary Quantity Bonus - The primary quantity bonus quantity recorded on the last operation performed for the Processed state
-
Processed Primary Quantity Loss - The primary quantity loss quantity recorded on the last operation performed for the Processed state
-
Processed Secondary Quantity Bonus - The secondary quantity bonus quantity recorded on the last operation performed for the Processed state
-
Processed Secondary Quantity Loss - The secondary quantity loss quantity recorded on the last operation performed for the Processed state
-
Queued Primary Quantity - The primary quantity recorded for the first operation at the material and step. The operations that create a new Material Movement record are: Create, MoveToNextStep, MoveToStep, ExpandFrom, SplitFrom, ChangeFlowAndStep, Receive and Rework
-
Queued Secondary Quantity - The primary quantity recorded for the first operation at the material and step. The operations that create a new Material Movement record are: Create, MoveToNextStep, MoveToStep, ExpandFrom, SplitFrom, ChangeFlowAndStep, Receive and Rework
-
Queued Sub Materials Primary Quantity - The Sub material primary quantity recorded for the first operation at the material and step. The operations that create a new Material Movement record are: Create, MoveToNextStep, MoveToStep, ExpandFrom, SplitFrom, ChangeFlowAndStep, Receive and Rework
-
Queued Sub Materials Primary Quantity Bonus - The Sub Material primary quantity bonus quantity recorded on the last operation performed for the Queued state
-
Queued Sub Materials Primary Quantity Loss - The Sub Material primary quantity loss quantity recorded on the last operation performed for the Queued state
-
Queued Sub Materials Secondary Quantity - The Sub Material secondary quantity recorded for the first operation at the material and step. The operations that create a new Material Movement record are: Create, MoveToNextStep, MoveToStep, ExpandFrom, SplitFrom, ChangeFlowAndStep, Receive and Rework
-
Queued Sub Materials Secondary Quantity Bonus - The Sub Material secondary quantity bonus quantity recorded on the last operation performed for the Queued state
-
Queued Sub Materials Secondary Quantity Loss - The Sub Material secondary quantity loss quantity recorded on the last operation performed for the Queued state
-
Queued Primary Output Quantity - The primary quantity recorded on the last operation performed for the Queued state
-
Queued Secondary Output Quantity - The secondary quantity recorded on the last operation performed for the Queued state
-
Queued Sub Materials Primary Output Quantity - The Sub Material primary quantity recorded on the last operation performed for the Queued state
-
Queued Sub Materials Secondary Output Quantity - The Sub Material secondary quantity recorded on the last operation performed for the Queued state
-
Queued Primary Quantity Bonus - The primary quantity bonus quantity recorded on the last operation performed for the Queued state
-
Queued Primary Quantity Loss - The primary quantity loss quantity recorded on the last operation performed for the Queued state
-
Queued Secondary Quantity Bonus - The secondary quantity bonus quantity recorded on the last operation performed for the Queued state
-
Queued Secondary Quantity Loss - The secondary quantity loss quantity recorded on the last operation performed for the Queued state
-
Abort Process Count - The number of Abort Process operation occurrences
-
Dispatch Count - The number of Dispatch operation occurrences
-
Material Movement Count - The number of times that one initial operation occurred for a material and step combination. The operations that create a new Material Movement record are: Create, MoveToNextStep, MoveToStep, ExpandFrom, SplitFrom, ChangeFlowAndStep, Receive and Rework
-
Rework Count - The number of Rework operation occurrences
-
Terminated Count - The number of Terminate Material operation occurrences
-
Total Loss Primary Quantity - The total of all the primary quantity loss quantity recorded
-
Total Loss Primary Quantity Detected Out Of Step - The total of all the primary quantity loss quantity recorded through a reason defined with a loss step. Note that this is only considered if the material has been previously processed at the loss step
-
Total Loss Secondary Quantity - The total of all the secondary quantity loss quantity recorded
-
Total Loss Secondary Quantity Detected Out Of Step - The total of all the secondary quantity loss quantity recorded through a reason defined with a loss step. Note that this is only considered if the material has been previously processed at the loss step
-
Total Loss Sub Materials Primary Quantity Detected Out of Step - The total of all the primary quantity loss quantity recorded in sub-materials through a reason defined with a loss step. Note that this is only considered if the material has been previously processed at the loss step
-
Total Loss Sub Materials Secondary Quantity Detected Out of Step - The total of all the secondary quantity loss quantity recorded in sub-materials through a reason defined with a loss step. Note that this is only considered if the material has been previously processed at the loss step
-
Track In Count - The number of Track In operation occurrences
-
Track Out Count - The number of Track Out operation occurrences
Material Quality#
This section describes the Material Quality Measure Group.
Lags#
- Hold Lag - The duration in seconds between the Hold operation and the next Release operation
Material Quantities#
-
Material Quality Primary Quantity - The primary quantity when a Loss, Bonus, or Hold operation occurs
-
Material Quality Secondary Quantity - The secondary quantity when a Loss, Bonus, or Hold operation occurs
-
Material Quality Sub Materials Primary Quantity Loss - The primary Quantity of Sub Materials when a Loss, Bonus, or Hold operation occurs
-
Material Quality Sub Materials Secondary Quantity Loss - The secondary Quantity of Sub when a Loss, Bonus, or Hold operation occurs
Reason Quantities#
-
Reason Primary Quantity - The primary quantity for the Bonus reason or Loss reason
-
Reason Secondary Quantity - The secondary quantity for the Bonus reason or Loss reason
Others#
- Accepted Primary Quantity
- Affected Accepted Primary Quantity
- Affected Failed Primary Quantity
- Affected False Defect Primary Quantity
- Affected Fixed Primary Quantity
- Affected Not Fixable Primary Quantity
- Failed Primary Quantity
- False Defect Primary Quantity
- Fixed Primary Quantity
- Good Pieces - Processed Primary Quantity - Min(Accepted Primary Quantity + Fixed Primary Quantity + Not Fixable Primary Quantity, Processed Primary Quantity)
- Loss Primary Quantity
- Material Quality Count - Number of occurrences
- Not Fixable Primary Quantity
- Number of Defects
- Out of Process First Pass Yield
- Pass Test
- Pass Yield
- Passed Pieces - Processed Primary Quantity - Min(Failed Primary Quantity, Processed Primary Quantity)
- Total Pieces - Processed Primary Quantity + Losses Primary Quantity
- Total Primary Quantity
Resource Material Loss Bonus#
This section describes the Material Resource Material Loss Bonus Measure Group.
-
Primary Quantity Bonus - The bonus primary quantity
-
Secondary Quantity Bonus - The bonus secondary quantity
-
Primary Quantity Loss - The loss primary quantity
-
Secondary Quantity Loss - The loss secondary quantity
-
Material Loss Bonus Count - The number of occurrences
Dimensions and Measure Groups#
The table below lists the relationship between Material dimensions and measure groups
| Dimension | Material | Material Attribute | Material Movement | Material Quality | Resource Material Loss Bonus |
|---|---|---|---|---|---|
| Area | X | X | X | X | X |
| Bonus Reason | X | ||||
| Date | X | X | X | X | |
| Dispatched Date | X | ||||
| Dispatched Employee | X | ||||
| Dispatched Shift | X | ||||
| Dispatched Team | X | ||||
| Dispatched Time | X | ||||
| Employee | X | X | X | X | |
| Facility | X | X | X | X | X |
| Fiscal Date | X | X | X | X | |
| Flow | X | X | X | X | X |
| In Process Date | X | ||||
| In Process Employee | X | ||||
| In Process Shift | X | ||||
| In Process Team | X | ||||
| In Process Time | X | ||||
| Loss Reason | X | ||||
| Material | X | X | X | X | X |
| Material Attribute | X | X | |||
| Material Attribute String Value | X | X | |||
| Material Hierarchy | X | X | X | X | |
| Material State | X | ||||
| Operation | X | X | |||
| Parent Material | X | X | X | ||
| Processed Date | X | ||||
| Processed Employee | X | ||||
| Processed Shift | X | ||||
| Processed Team | X | ||||
| Processed Time | X | ||||
| Product | X | X | X | X | X |
| Product Group | X | X | X | X | X |
| Production Order | X | X | X | X | X |
| Quality - Reason | X | ||||
| Queued Date | X | ||||
| Queued Employee | X | X | |||
| Queued Shift | X | ||||
| Queued Team | X | ||||
| Queued Time | X | ||||
| Related Material | X | ||||
| Release from Hold Date | X | ||||
| Release from Hold Fiscal Date | X | ||||
| Release from Hold Time | X | ||||
| Release Shift | X | ||||
| Resource | X | X | X | X | X |
| Service | X | X | |||
| Shift | X | X | X | X | |
| Step | X | X | X | X | X |
| Step Output Date | X | ||||
| Step Output Employee | X | ||||
| Step Output Shift | X | ||||
| Step Output Team | X | ||||
| Step Output Time | X | ||||
| Team | X | X | |||
| Time | X | X | X | X | |
| Unit - Primary | X | X | X | X | X |
| Unit - Secondary | X | X | X | X | X |
Table: Material Cube - Dimensions and Measure Groups