Attributes
The mapping guide describes the available attributes for each dimension.
This table shows the dimensions targeted by the production operation fact:
| Dimension | Type | Note |
|---|---|---|
| Calculation Office | Conformed | From Production Order |
| Company | Conformed | tisfc010.compnr or ticst002.compnr |
| Financial Company | Conformed | If Financial Transactions by Work Center (tisfc001_rswc) =
Yes, the Financial Company of the Work Center Else, the Financial Company of the Production Order |
| Item | Conformed | From Production Order (1) |
| Machine | Conformed | tisfc010.mcno or ticst002.mcno |
| PCS Project | Conformed | From Production Order |
| Planner | Conformed | From Production Order |
| Production Operation | Domain specific | tisfc010.pdno + tisfc010.opno or ticst002.pdno + ticst002.opno |
| Production Operation Detail | Domain specific | Junk dimension |
| Production Order | Domain specific | tisfc010.pdno or ticst002.pdno |
| Production Order Detail | Domain specific | Junk dimension |
| Shop Floor Planner | Conformed | From Production Order |
| Site | Conformed | From Production Order |
| Task | Conformed | tisfc010.tano |
| Time | Birst | (2) Start Date + End Date |
| Work Center | Conformed | tisfc010.cwoc or ticst002.cwoc |
- (1) The Product Variant dimension is not targeted for production orders. In LN, a unique item exists for each product variant used in Job Shop. In Job Shop BI, the product variant becomes an attribute in the Item dimension.
- (2) You can analyze by two production operation dates: Start Date and
End Date.
- Start Date = Actual Start Date. Setup + Run Start Date if there is no Actual Start Date.
- End Date = Completion Date. Wait Start Date if there is no Completion Date.