Production Total Cost (Job Shop)
The Production Total Cost fact includes measures based on End Item Unit Costs (ticst010) from Job Shop.
Transformation of extracted data:
- Costs
- LN has separate Cost View records for work center-based costs and item-based costs. LN Analytics
- Deleted lines
- Deleted End Item Unit Costs are stored in the Production Total Cost fact table. These facts are hidden if the production order does not have estimated costs frozen. End Item Unit Costs that are deleted for production orders that have estimated costs frozen (when archiving orders) are not hidden and remain available for analysis. has one consolidated record with separate work center and item measures.
These dimensions are production order related and available for total cost analysis:
- Site, Calculation Office
- Item, PCS Project
- Planner, Shop Floor Planner
- Production Order Detail, Production Order (not drawn in the star schema due to limited space)
The production order related dimensions allow you, for example, to analyze what the total costs were for rework orders.
This diagram shows the star schema:
