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.