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 NoBuilt as  ORDER_NO + ' - ' +  SEQUENCE_NO  + ' - ' + RELEASE_NO + ' - ' + OPERATION_NO
SO Operation MilestoneIs the operation defined as a milestone?
SO Operation Purch Order NoCorresponding purchase order number.
SO Operation StatusStatus of Shop Order operation. I.e. Cancelled, Planned, Released etc
SO Operation ResourceResource identity.
SO Operation Interruption CauseCause of operation interruption.
SO Operation Order NoCorresponding 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 OPERATIONFACT_SHOP_ORDER_OPERATION_BIFACT_SHOP_ORDER_OPERATIONOn Line