Tabular Model - Production Performance

Contents

Usage/Purpose

Main analysis scenarios are:

Fact Tables

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
SHOP ORDER MATERIAL MEASURESFACT_SHOP_ORDER_MATERIAL_TMFACT_SHOP_ORDER_MATERIAL_BIFACT_SHOP_ORDER_MATERIALData Mart
SHOP ORDER MEASURESFACT_SHOP_ORDER_TMFACT_SHOP_ORDER_BIFACT_SHOP_ORDERData Mart
SHOP ORDER OPERATION HIST MEASURESFACT_OPERATION_HISTORY_TMFACT_OPERATION_HISTORY_BIFACT_OPERATION_HISTORYData Mart
SHOP ORDER OPERATION MEASURESFACT_SHOP_ORDER_OPERATION_TMFACT_SHOP_ORDER_OPERATION_BIFACT_SHOP_ORDER_OPERATIONData 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.

Dimension Tables

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
ACTIVITYDIM_ACTIVITY_TMDIM_ACTIVITY_BIDIM_ACTIVITYOn Line
ACTUAL FINISH DATEDIM_BI_TIME_BIDIM_BI_TIME_BIDIM_BI_TIMEOn Line
CLOSED DATEDIM_BI_TIME_BIDIM_BI_TIME_BI DIM_BI_TIME_BIOn Line
COMPANYDIM_COMPANY_TMDIM_COMPANY_BIDIM_COMPANYOn Line
CONDITION CODEDIM_CONDITION_CODE_BIDIM_CONDITION_CODE_BIDIM_CONDITION_CODEOn Line
CONFIGURATION SPECDIM_CONFIGURATION_SPEC_BIDIM_CONFIGURATION_SPEC_BIDIM_CONFIGURATION_SPECOn Line
CURRENCY CODEDIM_CURRENCY_CODE_TMDIM_CURRENCY_CODE_BIDIM_CURRENCY_CODEOn Line
CURRENCY RATE TYPEDIM_CURRENCY_RATE_TYPE_TMDIM_CURRENCY_RATE_TYPE_BIDIM_CURRENCY_RATE_TYPEOn Line
EARLIEST START DATE DIM_BI_TIME_BI DIM_BI_TIME_BI DIM_BI_TIME_BIOn Line
EMPLOYEEDIM_EMPLOYEE_TMDIM_EMPLOYEE_BIDIM_EMPLOYEEOn Line
FINISHED DATE DIM_BI_TIME_BI DIM_BI_TIME_BI DIM_BI_TIME_BIOn Line
INVENTORY PARTDIM_INVENTORY_PART_TMDIM_INVENTORY_PART_BIDIM_INVENTORY_PARTOn Line
LABOR CLASSDIM_LABOR_CLASS_TMDIM_LABOR_CLASS_BIDIM_LABOR_CLASSOn Line
NEED DATE DIM_BI_TIME_BI DIM_BI_TIME_BI DIM_BI_TIME_BIOn Line
PLANNED FINISH DATEDIM_BI_TIME_BIDIM_BI_TIME_BIDIM_BI_TIMEOn Line
PLANNERDIM_PLANNER_TMDIM_PLANNER_BIDIM_PLANNEROn Line
PRODUCTION LINEDIM_PRODUCTION_LINE_TMDIM_PRODUCTION_LINE_BIDIM_PRODUCTION_LINEOn Line
PROJECTDIM_PROJECT_TMDIM_PROJECT_BIDIM_PROJECTOn Line
REPORTING CURRENCYDIM_REPORTING_CURRENCY_TMFACT_CURRENCY_RATES_BI,LUP_REP_CURR_RATE_TYPE_TC,DIM_CURRENCY_CODE_BI,DIM_CURRENCY_RATE_TYPE_BIDIM_REPORTING_CURRENCYOn Line
REPORTING DATEDIM_BI_TIME_BIDIM_BI_TIME_BIDIM_BI_TIMEOn Line
REPORTING PERIODDIM_REPORTING_PERIOD_MAINTENANCE_TMDIM_RDP_COMPANY_PERIOD_BIDIM_REPORTING_PERIOD_MAINTENANCEOn Line
REQUIRED DATE DIM_BI_TIME_BI DIM_BI_TIME_BI DIM_BI_TIME_BIOn Line
SHOP ORDERFACT_SHOP_ORDER_TMFACT_SHOP_ORDER_BIFACT_SHOP_ORDERData Mart
SHOP ORDER MATERIALFACT_SHOP_ORDER_MATERIAL_TMFACT_SHOP_ORDER_MATERIAL_BIFACT_SHOP_ORDER_MATERIALData Mart
SHOP ORDER OPERATIONFACT_SHOP_ORDER_OPERATION_TMFACT_SHOP_ORDER_OPERATION_BIFACT_SHOP_ORDER_OPERATIONData Mart
SHOP ORDER OPERATION HISTFACT_OPERATION_HISTORY_TMFACT_OPERATION_HISTORY_BIFACT_OPERATION_HISTORYData Mart
SITEDIM_SITE_TMDIM_SITE_BIDIM_SITEOn Line
START DATE DIM_BI_TIME_BI DIM_BI_TIME_BI DIM_BI_TIME_BIOn Line
WORK CENTERDIM_WORK_CENTER_TMDIM_WORK_CENTER_BIDIM_WORK_CENTEROn Line

Configurations

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.

Limitations

Combinations of facts and dimensions that do not match will not give any results

Relationships

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)
CURRENCY RATES (DIM_TIME_ID) - REPORTING DATE (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 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)