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

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

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

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

Attributes

Attribute Description (where applicable)
CONTRACT
ATTRIBUTE_RESULT_STATUS
ATTRIBUTE_RESULT_STATUS_DESC
CATEGORY_RESULT_STATUS
CATEGORY_RESULT_STATUS_DESC
ACCEPT_SAMPLING_STATUS
ACCEPT_SAMPLING_STATUS_DESC
CONTROL_PLAN_NO
ANALYSIS_NO_KEY
COUNT_WITHIN_SPECIFICATION
COUNT_PARTLY_IN_SPECIFICATION
COUNT_OUT_OF_SPECIFICATION
COUNT_ATTRIBUTE_CONFORMING
CNT_ATTR_NON_CONFORMITY_EXISTS
COUNT_CATEGORY_CONFORMING
CNT_CAT_NON_CONFORMITY_EXISTS
ANALYSIS_NO
Part ID
ORDER_NO
RELEASE_NO
REAL_TIME_SPC_DESC
PART_NO
TIME_CREATED
VARIABLE_RESULT_STATUS_DESC
TIME_CONFIRMED
SEQUENCE_NO
OPERATION_NO
VARIABLE_RESULT_STATUS
REAL_TIME_SPC
WORK_CENTER_NO

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 ANALYSISFACT_SHOP_ORDER_ANALYSES_BIFACT_SHOP_ORDER_ANALYSESOn Line