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.