This Tabular Model is used for: Production Performance. There is a list of Tabular Models pre-packaged and delivered as a part of IFS Analysis Models, and you can refer to them here.
Main analysis scenarios are:
| Model Table | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| SHOP ORDER ANALYSIS MEASURES | ||||
| SHOP ORDER MATERIAL MEASURES | FACT_SHOP_ORDER_MATERIAL_TM | FACT_SHOP_ORDER_MATERIAL_BI | FACT_SHOP_ORDER_MATERIAL | Data Mart |
| SHOP ORDER MEASURES | FACT_SHOP_ORDER_TM | FACT_SHOP_ORDER_BI | FACT_SHOP_ORDER | Data Mart |
| SHOP ORDER OPERATION HIST MEASURES | FACT_OPERATION_HISTORY_TM | FACT_OPERATION_HISTORY_BI | FACT_OPERATION_HISTORY | Data Mart |
| SHOP ORDER OPERATION MEASURES | FACT_SHOP_ORDER_OPERATION_TM | FACT_SHOP_ORDER_OPERATION_BI | FACT_SHOP_ORDER_OPERATION | Data Mart |
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 | DW Source view (SQL Server) | BI Access View | Referenced Information Source | Recommended Access Type |
| ACTIVITY | DIM_ACTIVITY_TM | DIM_ACTIVITY_BI | DIM_ACTIVITY | On Line |
| ACTUAL FINISH DATE | DIM_BI_TIME_BI | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| CLOSED DATE | DIM_BI_TIME_BI | DIM_BI_TIME_BI | DIM_BI_TIME_BI | On Line |
| COMPANY | DIM_COMPANY_TM | DIM_COMPANY_BI | DIM_COMPANY | On Line |
| COMPLETED DATE | ||||
| CONDITION CODE | DIM_CONDITION_CODE_BI | DIM_CONDITION_CODE_BI | DIM_CONDITION_CODE | On Line |
| CONFIGURATION SPEC | DIM_CONFIGURATION_SPEC_BI | DIM_CONFIGURATION_SPEC_BI | DIM_CONFIGURATION_SPEC | On Line |
| CONFIRMED DATE | ||||
| CREATED DATE | ||||
| CURRENCY CODE | DIM_CURRENCY_CODE_TM | DIM_CURRENCY_CODE_BI | DIM_CURRENCY_CODE | On Line |
| CURRENCY RATE TYPE | DIM_CURRENCY_RATE_TYPE_TM | DIM_CURRENCY_RATE_TYPE_BI | DIM_CURRENCY_RATE_TYPE | On Line |
| EARLIEST START DATE | DIM_BI_TIME_BI | DIM_BI_TIME_BI | DIM_BI_TIME_BI | On Line |
| EMPLOYEE | DIM_EMPLOYEE_TM | DIM_EMPLOYEE_BI | DIM_EMPLOYEE | On Line |
| FINISHED DATE | DIM_BI_TIME_BI | DIM_BI_TIME_BI | DIM_BI_TIME_BI | On Line |
| INVENTORY PART | DIM_INVENTORY_PART_TM | DIM_INVENTORY_PART_BI | DIM_INVENTORY_PART | On Line |
| LABOR CLASS | DIM_LABOR_CLASS_TM | DIM_LABOR_CLASS_BI | DIM_LABOR_CLASS | On Line |
| LAST ACTIVITY DATE | ||||
| NEED DATE | DIM_BI_TIME_BI | DIM_BI_TIME_BI | DIM_BI_TIME_BI | On Line |
| PLANNED FINISH DATE | DIM_BI_TIME_BI | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| PLANNER | DIM_PLANNER_TM | DIM_PLANNER_BI | DIM_PLANNER | On Line |
| PRODUCTION LINE | DIM_PRODUCTION_LINE_TM | DIM_PRODUCTION_LINE_BI | DIM_PRODUCTION_LINE | On Line |
| PROJECT | DIM_PROJECT_TM | DIM_PROJECT_BI | DIM_PROJECT | On Line |
| REPORTING CURRENCY | DIM_REPORTING_CURRENCY_TM | FACT_CURRENCY_RATES_BI,LUP_REP_CURR_RATE_TYPE_TC,DIM_CURRENCY_CODE_BI,DIM_CURRENCY_RATE_TYPE_BI | DIM_REPORTING_CURRENCY | On Line |
| REPORTING DATE | DIM_BI_TIME_BI | DIM_BI_TIME_BI | DIM_BI_TIME | On Line |
| REPORTING PERIOD | DIM_REPORTING_PERIOD_MAINTENANCE_TM | DIM_RDP_COMPANY_PERIOD_BI | DIM_REPORTING_PERIOD_MAINTENANCE | On Line |
| REPORTING SECONDS | ||||
| REQUIRED DATE | DIM_BI_TIME_BI | DIM_BI_TIME_BI | DIM_BI_TIME_BI | On Line |
| SHOP ORDER | FACT_SHOP_ORDER_TM | FACT_SHOP_ORDER_BI | FACT_SHOP_ORDER | Data Mart |
| SHOP ORDER ANALYSIS | ||||
| SHOP ORDER ANALYSIS NORM | ||||
| SHOP ORDER ANALYSIS NORM MEASURES | ||||
| SHOP ORDER MATERIAL | FACT_SHOP_ORDER_MATERIAL_TM | FACT_SHOP_ORDER_MATERIAL_BI | FACT_SHOP_ORDER_MATERIAL | Data Mart |
| SHOP ORDER OPERATION | FACT_SHOP_ORDER_OPERATION_TM | FACT_SHOP_ORDER_OPERATION_BI | FACT_SHOP_ORDER_OPERATION | Data Mart |
| SHOP ORDER OPERATION HIST | FACT_OPERATION_HISTORY_TM | FACT_OPERATION_HISTORY_BI | FACT_OPERATION_HISTORY | Data Mart |
| SITE | DIM_SITE_TM | DIM_SITE_BI | DIM_SITE | On Line |
| START DATE | DIM_BI_TIME_BI | DIM_BI_TIME_BI | DIM_BI_TIME_BI | On Line |
| WORK CENTER | DIM_WORK_CENTER_TM | DIM_WORK_CENTER_BI | DIM_WORK_CENTER | On Line |
| WORK CENTER RESOURCE |
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) |
| CURRENCY RATES (DIM_CURRENCY_CODE_ID) - CURRENCY CODE (ID) |
| CURRENCY RATES (DIM_CURRENCY_RATE_TYPE_ID) - CURRENCY RATE TYPE (ID) |
| CURRENCY RATES (DIM_REPORTING_CURRENCY_ID) - REPORTING CURRENCY (ID) |
| SHOP ORDER (DIM_ACTIVITY_ID) - ACTIVITY (ID) |
| SHOP ORDER (DIM_COMPANY_ID) - COMPANY (ID) |
| SHOP ORDER (DIM_CONDITION_CODE_ID) - CONDITION CODE (ID) |
| SHOP ORDER (DIM_CONFIGURATION_SPEC_ID) - CONFIGURATION SPEC (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 (Dim_Reporting_Date_Id) - REPORTING DATE (ID) |
| SHOP ORDER (DIM_RPD_COMPANY_PERIOD_ID) - REPORTING PERIOD (Company-Date) |
| SHOP ORDER (DIM_SITE_ID) - SITE (ID) |
| SHOP ORDER (DIM_SO_CLOSE_DATE_ID) - CLOSED DATE (ID) |
| SHOP ORDER (DIM_SO_EARLIEST_START_DATE_ID) - EARLIEST START DATE (ID) |
| SHOP ORDER (DIM_SO_FINISH_DATE_ID) - FINISHED DATE (ID) |
| SHOP ORDER (DIM_SO_NEED_DATE_ID) - NEED DATE (ID) |
| SHOP ORDER (DIM_SO_START_DATE_ID) - START DATE (ID) |
| SHOP ORDER (REP_CURR_CODE) - REPORTING CURRENCY (ID) |
| SHOP ORDER ANALYSIS (DIM_ANALYSIS_DATE_CONFIRMED) - CONFIRMED DATE (ID) |
| SHOP ORDER ANALYSIS (DIM_ANALYSIS_DATE_CREATED) - CREATED DATE (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) |
| SHOP ORDER ANALYSIS NORM (DIM_INVENTORY_PART) - INVENTORY PART (ID) |
| SHOP ORDER ANALYSIS NORM (DIM_SITE_ID) - SITE (ID) |
| SHOP ORDER ANALYSIS NORM (LAST_ACTIVITY_DATE) - COMPLETED DATE (ID) |
| SHOP ORDER ANALYSIS NORM (LAST_ACTIVITY_DATE) - LAST ACTIVITY DATE (ID) |
| SHOP ORDER MATERIAL (DIM_ACTIVITY_ID) - ACTIVITY (ID) |
| SHOP ORDER MATERIAL (DIM_COMPANY_ID) - COMPANY (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_Reporting_Date_Id) - REPORTING DATE (ID) |
| SHOP ORDER MATERIAL (DIM_RPD_COMPANY_PERIOD_ID) - REPORTING PERIOD (Company-Date) |
| SHOP ORDER MATERIAL (DIM_SITE_ID) - SITE (ID) |
| SHOP ORDER MATERIAL (DIM_SO_MAT_REQUIRED_DATE_ID) - REQUIRED DATE (ID) |
| SHOP ORDER OPERATION (DIM_ACTIVITY_ID) - ACTIVITY (ID) |
| SHOP ORDER OPERATION (DIM_INVENTORY_PART_ID) - INVENTORY PART (ID) |
| SHOP ORDER OPERATION (DIM_LABOR_CLASS_NO_ID) - LABOR CLASS (ID) |
| SHOP ORDER OPERATION (DIM_OP_ACTUAL_FINISH_DATE_ID) - ACTUAL FINISH DATE (ID) |
| SHOP ORDER OPERATION (DIM_OP_PLAN_FINISH_DATE_ID) - PLANNED FINISH DATE (ID) |
| SHOP ORDER OPERATION (DIM_PLANNER_ID) - PLANNER (ID) |
| SHOP ORDER OPERATION (DIM_PRODUCTION_LINE_ID) - PRODUCTION LINE (ID) |
| SHOP ORDER OPERATION (DIM_PROJECT_ID) - PROJECT (ID) |
| SHOP ORDER OPERATION (Dim_Reporting_Date_Id) - REPORTING DATE (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 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_INVENTORY_PART) - INVENTORY PART (ID) |
| SHOP ORDER OPERATION HIST (DIM_LABOR_CLASS_NO_ID) - LABOR CLASS (ID) |
| SHOP ORDER OPERATION HIST (DIM_PROJECT_ID) - PROJECT (ID) |
| SHOP ORDER OPERATION HIST (Dim_Reporting_Date_Id) - REPORTING DATE (ID) |
| SHOP ORDER OPERATION HIST (DIM_RPD_COMPANY_PERIOD_ID) - REPORTING PERIOD (Company-Date) |
| SHOP ORDER OPERATION HIST (DIM_SITE_ID) - SITE (ID) |
| SHOP ORDER OPERATION HIST (DIM_WORK_CENTER_ID) - WORK CENTER (ID) |
| WORK CENTER RESOURCE (Work Center ID) - WORK CENTER (ID) |