Attributes
The mapping guide describes the available attributes for each dimension.
This table shows the dimensions targeted by the production material fact:
| Dimension | Type | Note |
|---|---|---|
| Calculation Office | Conformed | From Production Order |
| Company | Conformed | ticst001.compnr |
| Financial Company | Conformed | If Financial Transactions by Work Center (tisfc001_rswc) =
No or no operation, Financial Company of Production Order. Else, Financial Company of Production Operation. |
| Item | Conformed | From Production Order (1) |
| Material | Conformed | ticst001.sitm |
| PCS Project | Conformed | From Production Order |
| Planner | Conformed | From Production Order |
| Production Material | Domain specific | ticst001.pdno + ticst001.pono |
| Production Material Detail | Domain specific | Junk dimension |
| Production Operation | Domain specific | ticst001.pdno + ticst001.opno |
| Production Order | Domain specific | ticst001.pdno |
| Production Order Detail | Domain specific | Junk dimension |
| Shop Floor Planner | Conformed | From Production Order |
| Site | Conformed | From Production Order |
| Time | Birst | (2) Start Date + End Date |
| Warehouse | Conformed | ticst001.cwar (3) Material warehouse |
| Work Center | Conformed | From Production Operation |
- (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 Start Date and End Date.
Start Date = Operation Start Date. Order Start Date if no operation.
End Date = Operation End Date. Order End Date if no operation.
Where Start Date and End Date are calculated as in the Production Order and Production Operation facts:
- Operation Start Date = Actual Start Date. Setup + Run Start Date if there is no Actual Start Date.
- Order Start Date = Actual Start Date. Planned Start Date if there is no Actual Start Date.
- Operation End Date = Completion Date. Wait Start Date if there is no Completion Date.
- Order End Date = Completion Date. Planned Delivery Date if there is no Completion Date.
- (3) Warehouse is the material warehouse, not the produced item warehouse.