Production Material (Job Shop)

The Production Material fact includes measures based on Estimated and Actual Material Costs (ticst001) from Job Shop.

Transformation of extracted data:

Deleted lines
Deleted Estimated and Actual Material Costs are stored in the Production Material fact table. These facts are hidden if the production order does not have estimated costs frozen. Estimated and Actual Material Costs that are deleted for production orders that have estimated costs frozen (when archiving orders) are not hidden and remain available for analysis.

These dimensions are production order/operation related and available for material analysis:

  • Site, Calculation Office
  • Item, PCS Project
  • Planner, Shop Floor Planner
  • Production Order Detail, Production Order, Production Operation (not drawn in the star schema due to limited space)

The production order related dimensions allow you to, for example, analyze how much material was used for rework orders.

This diagram shows the star schema:

Production material star schema