Attributes
The mapping guide describes the available attributes for each dimension.
This table shows the dimensions targeted by the production order fact:
| Dimension | Type | Note |
|---|---|---|
| Calculation Office | Conformed | tisfc001.clco |
| Company | Conformed | tisfc001.compnr |
| Financial Company | Conformed | Targeted using tisfc001.clco |
| Item | Conformed | tisfc001.mitm (1) |
| PCS Project | Conformed | tisfc001.cprj |
| Planner | Conformed | tisfc001.plid |
| Production Order | Domain specific | tisfc001.pdno |
| Production Order Detail | Domain specific | Junk dimension |
| Shop Floor Planner | Conformed | tisfc001.sfpl |
| Site | Conformed | tisfc001.site |
| Time | Birst | (2) Start Date + End Date |
| Warehouse | Conformed | tisfc001.cwar |
- (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 dates on the production order: Start Date
and End Date.
- Start Date = Actual Start Date. Planned Start Date if there is no Actual Start Date.
- End Date = Completion Date. Planned Delivery Date if there is no Completion Date.