Model: Production Performance - Specifications for Dimension Table: SHOP ORDER OPERATION

On this page you will find the specifications regarding the Model: Production Performance and Dimension Table: SHOP ORDER OPERATION.

This model fact represents shop order operation information and is based on the view FACT_SHOP_ORDER_OPERATION_BI.

Note: Please refer to documentation of each model to find out about attributes used in referenced models.

Attributes

Attribute Description (where applicable)
SO Op Order No Built as  ORDER_NO + ' - ' +  SEQUENCE_NO  + ' - ' + RELEASE_NO + ' - ' + OPERATION_NO
SO Operation Milestone Is the operation defined as a milestone?
SO Operation Purch Order No Corresponding purchase order number.
SO Operation Status Status of Shop Order operation. I.e. Cancelled, Planned, Released etc
SO Operation Resource Resource identity.
SO Operation Interruption Cause Cause of operation interruption.
SO Operation Order No Corresponding shop order number.

USED BY MODEL(S)

Model Name
Production Performance

Data source Information

The data source for this object is defined using IFS Developer Tool. Further Transformations are done using Power BI.

Additional information can be found in the online documentation of Information Sources.

Model Table BI Access View Referenced Information Source Recommended Access Type
SHOP ORDER OPERATION FACT_SHOP_ORDER_OPERATION_BI FACT_SHOP_ORDER_OPERATION On Line