Attributes

The mapping guide describes the available attributes for each dimension.

This table shows the dimensions targeted by the production total cost fact:

Dimension Type Note
Calculation Office Conformed From Production Order
Company Conformed ticst010.compnr
Cost Component Conformed ticst010.cpcp
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)
PCS Project Conformed From Production Order
Planner Conformed From Production Order
Production Order Domain specific ticst010.pdno
Production Order Detail Domain specific Junk dimension
Production Total Cost Detail Domain specific Junk dimension
Shop Floor Planner Conformed From Production Order
Site Conformed From Production Order
Time Birst (2) Start Date + End Date
Work Center Conformed ticst010.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 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.