This Analysis Model is used for: Production Performance. There is a list of Analysis Models pre-packaged and delivered as a part of Analysis Models - Power BI, and you can refer to them here.
Main analysis scenarios are:
| Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
| SHOP ORDER MEASURES | FACT_SHOP_ORDER_BI | FACT_SHOP_ORDER | On Line |
| SHOP ORDER MATERIAL MEASURES | FACT_SHOP_ORDER_MATERIAL_BI | FACT_SHOP_ORDER_MATERIAL | On Line |
| SHOP ORDER OPERATION HIST MEASURES | FACT_OPERATION_HISTORY_BI | FACT_OPERATION_HISTORY | On Line |
| SHOP ORDER OPERATION MEASURES | FACT_SHOP_ORDER_OPERATION_BI | FACT_SHOP_ORDER_OPERATION | On Line |
| SHOP ORDER ANALYSIS MEASURES | FACT_SHOP_ORDER_ANALYSES_BI | FACT_SHOP_ORDER_ANALYSES | On Line |
Corresponding Information Sources are described below. Detailed infomation about Information Sources can be found in About Information Sources
FACT_SHOP_ORDER
The Shop Order fact is mainly based on IFS/Shop Order. The main purpose of this fact is to present shop order data to support high level summarizations and analyses to evaluate the shop floor performance, for instance, using the Count Perfect Shop Order metrics.
FACT_SHOP_ORDER_MATERIAL
The Shop Order Material fact is mainly based on shop order material and material history. The main purpose of this fact is to present data based on the shop order material line to support creation of analysis reports that focus on statistics for consumables needed in the manufacturing process.
FACT_SHOP_ORDER_OPERATION
The Shop Order Operation fact is mainly based on shop order operation statistics, operation history and shop order costing. The main purpose of this fact is to present data based on the shop order operations to support summarizations and analysis to evaluate the manufacturing process.
FACT_OPERATION_HISTORY
The Shop Order Operation History fact is based on labor and operations history. The main purpose of this fact is to provide support for analysis of shop order operations. Since Employee, Created By Employee and Transaction Date exist as dimensions in this fact it is possible to create reports in the transaction level.
| Model Table | BI Access View | Referenced Information Source | Recommended Access Type |
| ACTIVITY | DIM_ACTIVITY_BI | DIM_ACTIVITY | On Line |
| REPORTING DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| COMPANY | DIM_COMPANY_BI | DIM_COMPANY | On Line |
| CONDITION CODE | DIM_CONDITION_CODE_BI | DIM_CONDITION_CODE | On Line |
| EMPLOYEE | DIM_EMPLOYEE_BI | DIM_EMPLOYEE | On Line |
| LABOR CLASS | DIM_LABOR_CLASS_BI | DIM_LABOR_CLASS | On Line |
| INVENTORY PART | DIM_INVENTORY_PART_BI | DIM_INVENTORY_PART | On Line |
| PLANNER | DIM_PLANNER_BI | DIM_PLANNER | On Line |
| PRODUCTION LINE | DIM_PRODUCTION_LINE_BI | DIM_PRODUCTION_LINE | On Line |
| PROJECT | DIM_PROJECT_BI | DIM_PROJECT | On Line |
| REPORTING PERIOD | DIM_REPORTING_PERIOD_MAINTENANCE_BI | DIM_REPORTING_PERIOD_MAINTENANCE | On Line |
| REPORTING CURRENCY | DIM_REPORTING_CURRENCY_PQ_BI | DIM_REPORTING_CURRENCY_PQ | On Line |
| SITE | DIM_SITE_BI | DIM_SITE | On Line |
| WORK CENTER | DIM_WORK_CENTER_BI | DIM_WORK_CENTER | On Line |
| SHOP ORDER OPERATION HIST | FACT_OPERATION_HISTORY_BI | FACT_OPERATION_HISTORY | On Line |
| SHOP ORDER MATERIAL | FACT_SHOP_ORDER_MATERIAL_BI | FACT_SHOP_ORDER_MATERIAL | On Line |
| SHOP ORDER OPERATION | FACT_SHOP_ORDER_OPERATION_BI | FACT_SHOP_ORDER_OPERATION | On Line |
| SHOP ORDER | FACT_SHOP_ORDER_BI | FACT_SHOP_ORDER | On Line |
| SHOP ORDER ANALYSIS NORM | FACT_SHOP_ORDER_ANALYSIS_NORM_BI | FACT_SHOP_ORD_ANALYSIS_NORM | On Line |
| SHOP ORDER ANALYSIS | FACT_SHOP_ORDER_ANALYSES_BI | FACT_SHOP_ORDER_ANALYSES | On Line |
| CONFIGURATION SPEC | DIM_CONFIGURATION_SPEC_BI | DIM_CONFIGURATION_SPEC | On Line |
| WORK CENTER RESOURCE | DIM_WORK_CENTER_RESOURCE_BI | DIM_WORK_CENTER_RESOURCE | On Line |
| REPORTING SECONDS | DIM_BI_TIME_SECONDS_TM | DIM_BI_TIME_SECONDS | On Line |
| ACTUAL FINISH DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| CLOSED DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| EARLIEST START DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| FINISHED DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| NEED DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| PLANNED FINISH DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| REQUIRED DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| START DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| SHOP ORDER ANALYSIS NORM MEASURES | |||
| CONFIRMED DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| CREATED DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| COMPLETED DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| LAST ACTIVITY DATE | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
The Production Performance Tabular Model supports calculation of base currency amounts to a reporting currency. To make this work it is necessary to create/select a currency rate type in one company as the rate source. The relevant configuration lookup must also be defined.
Please refer to Technical Documentation for more information.
Combinations of facts and dimensions that do not match will not give any results
The following table lists the relationships between tables and columns in the model.
| Relationship: Table (column) - Table (column) |
| SHOP ORDER (DIM_COMPANY_ID) - COMPANY (ID) |
| SHOP ORDER (DIM_ACTIVITY_ID) - ACTIVITY (ID) |
| SHOP ORDER (DIM_CONDITION_CODE_ID) - CONDITION CODE (ID) |
| SHOP ORDER (DIM_CONFIGURATION_SPEC_ID) - CONFIGURATION SPEC (ID) |
| SHOP ORDER (DIM_SITE_ID) - SITE (ID) |
| SHOP ORDER (DIM_INVENTORY_PART_ID) - INVENTORY PART (ID) |
| SHOP ORDER (DIM_PLANNER_ID) - PLANNER (ID) |
| SHOP ORDER (DIM_PROJECT_ID) - PROJECT (ID) |
| SHOP ORDER MATERIAL (DIM_ACTIVITY_ID) - ACTIVITY (ID) |
| SHOP ORDER MATERIAL (DIM_CONDITION_CODE_ID) - CONDITION CODE (ID) |
| SHOP ORDER MATERIAL (DIM_INVENTORY_PART_ID) - INVENTORY PART (ID) |
| SHOP ORDER MATERIAL (DIM_PLANNER_ID) - PLANNER (ID) |
| SHOP ORDER MATERIAL (DIM_PROJECT_ID) - PROJECT (ID) |
| SHOP ORDER MATERIAL (DIM_SITE_ID) - SITE (ID) |
| SHOP ORDER OPERATION (DIM_ACTIVITY_ID) - ACTIVITY (ID) |
| SHOP ORDER OPERATION (DIM_INVENTORY_PART_ID) - INVENTORY PART (ID) |
| SHOP ORDER OPERATION (DIM_PLANNER_ID) - PLANNER (ID) |
| SHOP ORDER OPERATION (DIM_PRODUCTION_LINE_ID) - PRODUCTION LINE (ID) |
| SHOP ORDER OPERATION HIST (DIM_ACTIVITY_ID) - ACTIVITY (ID) |
| SHOP ORDER OPERATION HIST (DIM_COMPANY_ID) - COMPANY (ID) |
| SHOP ORDER OPERATION HIST (DIM_EMPLOYEE_ID) - EMPLOYEE (ID) |
| SHOP ORDER OPERATION HIST (DIM_PROJECT_ID) - PROJECT (ID) |
| SHOP ORDER OPERATION HIST (DIM_SITE_ID) - SITE (ID) |
| SHOP ORDER OPERATION HIST (DIM_WORK_CENTER_ID) - WORK CENTER (ID) |
| SHOP ORDER OPERATION HIST (DIM_LABOR_CLASS_NO_ID) - LABOR CLASS (ID) |
| SHOP ORDER OPERATION HIST (DIM_INVENTORY_PART) - INVENTORY PART (ID) |
| SHOP ORDER OPERATION (DIM_LABOR_CLASS_NO_ID) - LABOR CLASS (ID) |
| SHOP ORDER (REP_CURR_CODE) - REPORTING CURRENCY (ID) |
| SHOP ORDER (Dim_Reporting_Date_Id) - REPORTING DATE (ID) |
| SHOP ORDER (DIM_SO_EARLIEST_START_DATE_ID) - EARLIEST START DATE (ID) |
| SHOP ORDER (DIM_SO_START_DATE_ID) - START DATE (ID) |
| SHOP ORDER MATERIAL (Dim_Reporting_Date_Id) - REPORTING DATE (ID) |
| SHOP ORDER OPERATION HIST (Dim_Reporting_Date_Id) - REPORTING DATE (ID) |
| SHOP ORDER (DIM_RPD_COMPANY_PERIOD_ID) - REPORTING PERIOD (Company-Date) |
| SHOP ORDER MATERIAL (DIM_RPD_COMPANY_PERIOD_ID) - REPORTING PERIOD (Company-Date) |
| SHOP ORDER OPERATION HIST (DIM_RPD_COMPANY_PERIOD_ID) - REPORTING PERIOD (Company-Date) |
| SHOP ORDER OPERATION (DIM_OP_PLAN_FINISH_DATE_ID) - PLANNED FINISH DATE (ID) |
| SHOP ORDER OPERATION (DIM_OP_ACTUAL_FINISH_DATE_ID) - ACTUAL FINISH DATE (ID) |
| SHOP ORDER MATERIAL (DIM_SO_MAT_REQUIRED_DATE_ID) - REQUIRED DATE (ID) |
| SHOP ORDER (DIM_SO_CLOSE_DATE_ID) - CLOSED DATE (ID) |
| SHOP ORDER (DIM_SO_FINISH_DATE_ID) - FINISHED DATE (ID) |
| SHOP ORDER (DIM_SO_NEED_DATE_ID) - NEED DATE (ID) |
| CURRENCY RATES (DIM_CURRENCY_RATE_TYPE_ID) - CURRENCY RATE TYPE (ID) |
| CURRENCY RATES (DIM_CURRENCY_CODE_ID) - CURRENCY CODE (ID) |
| CURRENCY RATES (DIM_REPORTING_CURRENCY_ID) - REPORTING CURRENCY (ID) |
| SHOP ORDER ANALYSIS (DIM_SITE_ID) - SITE (ID) |
| SHOP ORDER ANALYSIS (DIM_WORK_CENTER_ID) - WORK CENTER (ID) |
| SHOP ORDER ANALYSIS (Part ID) - INVENTORY PART (ID) |
| WORK CENTER RESOURCE (Work Center ID) - WORK CENTER (ID) |
| SHOP ORDER ANALYSIS NORM (DIM_SITE_ID) - SITE (ID) |
| SHOP ORDER ANALYSIS NORM (DIM_INVENTORY_PART) - INVENTORY PART (ID) |
| SHOP ORDER ANALYSIS (DIM_ANALYSIS_DATE_CREATED) - CREATED DATE (ID) |
| SHOP ORDER ANALYSIS NORM (LAST_ACTIVITY_DATE) - LAST ACTIVITY DATE (ID) |
| SHOP ORDER ANALYSIS NORM (LAST_ACTIVITY_DATE) - COMPLETED DATE (ID) |
| SHOP ORDER OPERATION (Dim_Reporting_Date_Id) - REPORTING DATE (ID) |
| SHOP ORDER MATERIAL (DIM_COMPANY_ID) - COMPANY (ID) |
| SHOP ORDER OPERATION (DIM_PROJECT_ID) - PROJECT (ID) |
| SHOP ORDER OPERATION (DIM_RPD_COMPANY_PERIOD_ID) - REPORTING PERIOD (Company-Date) |
| SHOP ORDER OPERATION (DIM_SITE_ID) - SITE (ID) |
| SHOP ORDER OPERATION (DIM_WORK_CENTER_ID) - WORK CENTER (ID) |
| SHOP ORDER ANALYSIS (DIM_ANALYSIS_DATE_CONFIRMED) - CONFIRMED DATE (ID) |