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

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

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

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

Attributes

Attribute Description (where applicable)
INNER_MIN
INNER_MAX
CONTROL_CHART_TYPE
CONTROL_CHART_TYPE_DESC
INSPECTION_CODE
CONTRACT
LAST_ACTIVITY_DATE
DATE_COMPLETED
MVT_CREATED_DT
ANALYSIS_NO_KEY
DATA_POINT_KEY
ANALYSIS_MEAN
ANALYSIS_RANGE
ANALYSIS_STD_DEVIATION
ACCEPTANCE_NO
COUNT_NON_CONFORMING
COUNT_NON_CONFORMITIES_EXIST
ANALYSIS_NO
DATA_POINT
REJECTION_NO
STATUS
TEST_OPERATION_NO
REAL_TIME_SPC
REAL_TIME_SPC_DESC
NORM_TYPE
QTY_TO_CONTROL
TEST_OPERATION_DESCRIPTION
NON_CONFORM_QTY
PART_NO
OUTER_MIN
NORM_VALUE
REPORTED_BY
NON_CONFORMS
OUTER_MAX

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 ANALYSIS NORMFACT_SHOP_ORDER_ANALYSIS_NORM_BIFACT_SHOP_ORD_ANALYSIS_NORMOn Line