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.