Measures

This table shows the production total cost measures:

Measure	Mapping	Note
Item Actual Amount	ticst010.aamt
Item Actual Number of Units	ticst010.nuna	(1)
Item Amount Negative Variance	-1 * Item Amount Variance if negative, else 0
Item Amount Positive Variance	Item Amount Variance if positive, else 0
Item Amount Variance	Actual Amount – Estimate Amount
Item Estimated Amount	ticst010.eamt
Item Estimated Number of Units	ticst010.nune	(1)
Item Number of Units Negative Variance	-1 * Item Number of Units Variance if negative, else 0	(1)
Item Number of Units Positive Variance	Item Number of Units Variance if positive, else 0	(1)
Item Number of Units Variance	Actual Number of Units – Estimate Number of Units	(1)
Production Order Count Distinct	Distinct production order count
Production Total Cost Count	Count	Always 1, but 0 for null records
Work Center Actual Amount	ticst010.aamt
Work Center Actual Number of Units	ticst010.nuna
Work Center Amount Negative Variance	-1 * Work Center Amount Variance if negative, else 0
Work Center Amount Positive Variance	Work Center Amount Variance if positive, else 0
Work Center Amount Variance	Actual Amount – Estimate Amount
Work Center Estimated Amount	ticst010.eamt
Work Center Estimated Number of Units	ticst010.nune	(1)
Work Center Number of Units Negative Variance	-1 * Work Center Number of Units Variance if negative, else 0	(1)
Work Center Number of Units Positive Variance	Work Center Number of Units Variance if positive, else 0	(1)
Work Center Number of Units Variance	Actual Number of Units – Estimate Number of Units	(1)
deleted	1 if deleted in LN, else 0	(2)

• (1) Number of Units are fully additive (FA): LN does not associate the number of units with a unit of measure, therefore they can be summed across all dimensions.
• (2) This fact has deleted as a measure. For production order and operation, ‘deleted’ is an attribute in related dimensions.