IFS Analysis Model: Maintenance

This Analysis Model is used for: Maintenance. 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.

Contents

Usage/Purpose

Main analysis scenarios are:

Fact Tables

Model Table BI Access View Referenced Information Source Recommended Access Type
FACT TIME DIM_BI_TIME_BI DIM_BI_TIME On Line
WORK TASK POSTINGS FACT_JT_TASK_ACCT_PQ_BI FACT_JT_TASK_ACCT_PQ On Line
WO BUDGET FACT_WO_BUDGET_PQ_BI FACT_WO_BUDGET_PQ On Line
WORK TASK ACTUALS SALES FACT_WO_TASK_ACT_SALES_PQ_BI FACT_WO_TASK_ACT_SALES_PQ On Line
FACT WORK ORDER FACT_WORK_ORDER_PQ_BI FACT_WORK_ORDER_PQ On Line
WORK TASK ACTUALS COST FACT_WORK_TASK_ACT_COST_PQ_BI FACT_WORK_TASK_ACT_COST_PQ On Line
WORK TASK PLANNED FACT_WORK_TASK_PLANNED_PQ_BI FACT_WORK_TASK_PLANNED_PQ On Line
FACT WORK TASK FACT_WORK_TASK_PQ_BI FACT_WORK_TASK_PQ On Line
ASSET HEALTH MEASURES FACT_ASSET_HEALTH_BI FACT_ASSET_HEALTH On Line
CURRENCY RATES FACT_CURRENCY_RATES_PQ_BI FACT_CURRENCY_RATES_PQ On Line

 Corresponding Information Sources are described below. Detailed infomation about Information Sources can be found in About Information Sources

FACT_WO_TASK_ACTUALS_SALES
Work Order Actuals Sales Information Source is based on revenues related to Work Tasks. This Information Source carries transactions for time reporting, material issues, tools usages, expenses like revenue amounts.

FACT_WORK_TASK_ACTUALS_COST
Work Task Actuals Cost Information Source is based on costs related to Work Tasks. This information source carries transactions for Expenses, External, Fixed Price, Material, Personnel and Tool/Equipment.

FACT_WO_BUDGET
Work Order Budget Information Source is based on the manually entered budget costs and revenues on workorders. It should mainly be used in conjunction with Work Order Actuals information source for analysis.

FACT_WORK_TASK_PLANNED
Work Task Planned Information Source is based on the planning lines on the work tasks. It should mainly be used in conjunction with Work Task Actuals information source for analysis.

FACT_WORK_ORDERS
Work Order Information Source is based on IFS\Work Orders. This information source carries work orders in all statuses, i.e both active and historical work orders as well as work requests and fault reports.

FACT_WORK_TASK
A work order can have one or more work tasks connected to it. Work task is an entity which executes the work initiated, for example through a Fault Report or Service request. If IFS/Service Management is used, performed maintenance activities are reported, monitored and invoiced to customer through work tasks.

FACT_JT_TASK_ACCOUNTING
Work Task Accounting Information Source is based on actual transactions related to Work Tasks. It combines data from Work Order, Work Task, Work Task Transaction and Work Task Cost

Dimension Tables

Model Table BI Access View Referenced Information Source Recommended Access Type
ACCOUNT DIM_ACCOUNT_BI DIM_ACCOUNT On Line
ACTIVITY DIM_ACTIVITY_BI DIM_ACTIVITY On Line
CAUSE DIM_CAUSE_BI DIM_CAUSE On Line
CLASS DIM_CLASS_BI DIM_CLASS On Line
CANCEL TASK CAUSE DIM_CANCEL_TASK_CAUSE_BI DIM_CANCEL_TASK_CAUSE On Line
CODE B DIM_CODE_B_BI DIM_CODE_B On Line
CODE C DIM_CODE_C_BI DIM_CODE_C On Line
CODE D DIM_CODE_D_BI DIM_CODE_D On Line
CODE E DIM_CODE_E_BI DIM_CODE_E On Line
CODE F DIM_CODE_F_BI DIM_CODE_F On Line
CODE G DIM_CODE_G_BI DIM_CODE_G On Line
CODE H DIM_CODE_H_BI DIM_CODE_H On Line
CODE I DIM_CODE_I_BI DIM_CODE_I On Line
CODE J DIM_CODE_J_BI DIM_CODE_J On Line
COMPANY DIM_COMPANY_BI DIM_COMPANY On Line
COMPATIBLE UNIT DIM_CMPUNT_COMPATIBLE_UNIT_BI DIM_CMPUNT_COMPATIBLE_UNIT On Line
CUSTOMER DIM_CUSTOMER_BI DIM_CUSTOMER On Line
DISCOVERY DIM_DISCOVERY_BI DIM_DISCOVERY On Line
EVENT DIM_EVENT_BI DIM_EVENT On Line
FAILING COMPONENT DIM_FAILING_COMPONENT_BI DIM_FAILING_COMPONENT On Line
FAULT TYPE DIM_FAULT_TYPE_BI DIM_FAULT_TYPE On Line
ITEM CLASS FUNCTION DIM_ITEM_CLASS_FUNCTION_BI DIM_ITEM_CLASS_FUNCTION On Line
ITEM CLASS SOURCE DIM_IC_SOURCE_TYPE_BI DIM_IC_SOURCE_TYPE On Line
LINEAR ASSET DIM_LINAST_LINEAR_ASSET_PQ_BI DIM_LINAST_LINEAR_ASSET_PQ On Line
OPERATIONAL STATUS DIM_OPERATIONAL_STATUS_BI DIM_OPERATIONAL_STATUS On Line
ORGANIZATION DIM_ORGANIZATION_BI DIM_ORGANIZATION On Line
PERFORMED ACTION DIM_PERFORMED_ACTION_BI DIM_PERFORMED_ACTION On Line
PM GROUP DIM_PM_GROUP_BI DIM_PM_GROUP On Line
PRIORITY DIM_PRIORITY_BI DIM_PRIORITY On Line
PROJECT DIM_PROJECT_BI DIM_PROJECT On Line
PROJECT PROGRAM DIM_PROJECT_PROGRAM_BI DIM_PROJECT_PROGRAM On Line
REPORTING CURRENCY 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 PERIOD DIM_REPORTING_PERIOD_PQ_BI DIM_REPORTING_PERIOD_PQ On Line
SALES PART DIM_SALES_PART_BI DIM_SALES_PART On Line
SERVICE CONTRACT DIM_SERVICE_CONTRACT_LINE_BI DIM_SERVICE_CONTRACT_LINE On Line
SITE DIM_SITE_BI DIM_SITE On Line
SLA ORDER DIM_SLA_ORDER_BI DIM_SLA_ORDER On Line
SLA ORDER LINE DIM_SLA_ORDER_LINE_BI DIM_SLA_ORDER_LINE On Line
SOURCE CONNECTION DIM_JT_CONNECTED_OBJECT_BI DIM_JT_CONNECTED_OBJECT On Line
SOURCE OBJECT DIM_SOURCE_OBJECT_BI DIM_SOURCE_OBJECT On Line
SUPPLIER DIM_SUPPLIER_BI DIM_SUPPLIER On Line
SYMPTOM DIM_SYMPTOM_BI DIM_SYMPTOM On Line
TASK ACCOUNTING TYPE DIM_TASK_ACCOUNTING_TYPE_BI DIM_TASK_ACCOUNTING_TYPE On Line
TIME TYPE DIM_TIME_TYPE_BI DIM_TIME_TYPE On Line
TRANSACTION TYPE DIM_TRANSACTION_TYPE_BI DIM_TRANSACTION_TYPE On Line
VIM SERIAL DIM_VIM_SERIAL_BI DIM_VIM_SERIAL On Line
WO CONNECTION TYPE DIM_WO_CONNECTION_TYPE_BI DIM_WO_CONNECTION_TYPE On Line
WORK ORDER DIM_WORK_ORDER_BI DIM_WORK_ORDER On Line
WORK STAGE DIM_WORK_STAGE_BI DIM_WORK_STAGE On Line
WORK TASK DIM_WORK_TASK_BI DIM_WORK_TASK On Line
WORK TYPE DIM_WORK_TYPE_BI DIM_WORK_TYPE On Line
WORK TYPE CATEGORY DIM_WORK_TYPE_CATEGORY_BI DIM_WORK_TYPE_CATEGORY On Line
CRITICALITY DIM_CRITICALITY_BI DIM_CRITICALITY On Line
WO COST TYPE DIM_WO_COST_TYPE_BI DIM_WO_COST_TYPE On Line
ITEM CLASS DIM_ITEM_CLASS_PQ_BI DIM_ITEM_CLASS_PQ On Line
REPORTING DATE DIM_BI_TIME_BI DIM_BI_TIME On Line
SUB PROJECT DIM_SUB_PROJECT_PQ_BI DIM_SUB_PROJECT_PQ On Line
WT CONNECTION TYPE REPORTED DIM_WO_CONNECTION_TYPE_BI DIM_WO_CONNECTION_TYPE On Line
WT CONNECTION TYPE ACTUAL DIM_WO_CONNECTION_TYPE_BI DIM_WO_CONNECTION_TYPE On Line
VOUCHER DATE DIM_BI_TIME_BI DIM_BI_TIME On Line
SOURCE SITE DIM_SITE_BI DIM_SITE On Line
SLA LATEST START DATE DIM_BI_TIME_BI DIM_BI_TIME On Line
SLA LATEST FINISH DATE DIM_BI_TIME_BI DIM_BI_TIME On Line
REQUIRED START DATE DIM_BI_TIME_BI DIM_BI_TIME On Line
REQUIRED FINISH DATE DIM_BI_TIME_BI DIM_BI_TIME On Line
REPORTED OBJECT SITE DIM_SITE_BI DIM_SITE On Line
PLANNED START DATE DIM_BI_TIME_BI DIM_BI_TIME On Line
PLANNED FINISH DATE DIM_BI_TIME_BI DIM_BI_TIME On Line
PLANNED DATE DIM_BI_TIME_BI DIM_BI_TIME On Line
ORGANIZATION SITE DIM_SITE_BI DIM_SITE On Line
CREATED DATE DIM_BI_TIME_BI DIM_BI_TIME On Line
ACTUAL START DATE DIM_BI_TIME_BI DIM_BI_TIME On Line
ACTUAL OBJECT SITE DIM_SITE_BI DIM_SITE On Line
ACTUAL FINISH DATE DIM_BI_TIME_BI DIM_BI_TIME On Line
ACTUAL EQUIPMENT OBJECT DIM_EQUIPMENT_OBJECT_PQ_BI DIM_EQUIPMENT_OBJECT_PQ On Line
REPORTED EQUIPMENT OBJECT DIM_EQUIPMENT_OBJECT_BI DIM_EQUIPMENT_OBJECT On Line
ASSET TYPE DIM_ASSET_TYPE_BI DIM_ASSET_TYPE On Line
ASSET HEALTH HISTORY FACT_ASSET_HEALTH_HISTORY_BI FACT_ASSET_HEALTH_HISTORY On Line
ASSET HEALTH INDI HST FACT_ASSET_HEALTH_INDI_HST_BI FACT_ASSET_HEALTH_INDI_HST On Line
ASSET HEALTH INDICATOR FACT_ASSET_HEALTH_INDICATOR_BI FACT_ASSET_HEALTH_INDICATOR On Line
ASSET HEALTH LEVEL FACT_ASSET_HEALTH_LEVEL_BI FACT_ASSET_HEALTH_LEVEL On Line
ASSET HEALTH FACT_ASSET_HEALTH_BI FACT_ASSET_HEALTH On Line
ASSET HEALTH DIMENSION DIM_ASSET_HEALTH_BI DIM_ASSET_HEALTH On Line
ASSET HEALTH INDICATOR DIMENSION DIM_ASSET_HEALTH_INDICATOR_BI DIM_ASSET_HEALTH_INDICATOR On Line
COLOR LEVEL N/A EAM_COLOR_LEVEL On Line
EnvPath N/A EAM_ENVIRONMENT_PATH On Line
HEALTH LEVEL N/A EAM_HEALTH_LEVEL On Line
Locations N/A N/A

Configurations

n/a

Limitations

n/a

Relationships

The following table lists the relationships between tables and columns in the model.

Relationship: Table (column) - Table (column)
CURRENCY RATES (DIM_REPORTING_CURRENCY_ID) - REPORTING CURRENCY (ID)
CURRENCY RATES (DIM_TIME_ID) - REPORTING DATE (ID)
FACT TIME (ID) - ACTUAL FINISH DATE (ID)
FACT TIME (ID) - ACTUAL START DATE (ID)
FACT TIME (ID) - CREATED DATE (ID)
FACT TIME (ID) - PLANNED DATE (ID)
FACT TIME (ID) - PLANNED FINISH DATE (ID)
FACT TIME (ID) - PLANNED START DATE (ID)
FACT TIME (ID) - REPORTING DATE (ID)
FACT TIME (ID) - REQUIRED FINISH DATE (ID)
FACT TIME (ID) - REQUIRED START DATE (ID)
FACT TIME (ID) - SLA LATEST FINISH DATE (ID)
FACT TIME (ID) - SLA LATEST START DATE (ID)
FACT TIME (ID) - VOUCHER DATE (ID)
FACT WORK ORDER (Dim_Activity_ID) - ACTIVITY (ID)
FACT WORK ORDER (DIM_COMPANY_ID) - COMPANY (ID)
FACT WORK ORDER (Dim_Compatible_Unit_ID) - COMPATIBLE UNIT (ID)
FACT WORK ORDER (Dim_Customer_ID) - CUSTOMER (ID)
FACT WORK ORDER (Dim_Date_Actual_Complete_ID) - ACTUAL FINISH DATE (ID)
FACT WORK ORDER (Dim_Date_Actual_Start_ID) - ACTUAL START DATE (ID)
FACT WORK ORDER (Dim_Date_Created_ID) - CREATED DATE (ID)
FACT WORK ORDER (Dim_Date_Planned_Complete_ID) - PLANNED FINISH DATE (ID)
FACT WORK ORDER (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID)
FACT WORK ORDER (Dim_Date_Required_Complete_ID) - REQUIRED FINISH DATE (ID)
FACT WORK ORDER (Dim_Date_Required_Start_ID) - REQUIRED START DATE (ID)
FACT WORK ORDER (Dim_Discovery_ID) - DISCOVERY (ID)
FACT WORK ORDER (Dim_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID)
FACT WORK ORDER (Dim_Equipment_Object_ID) - REPORTED EQUIPMENT OBJECT (ID)
FACT WORK ORDER (Dim_Event_ID) - EVENT (ID)
FACT WORK ORDER (Dim_Linear_Asset_ID) - LINEAR ASSET (ID)
FACT WORK ORDER (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID)
FACT WORK ORDER (DIM_ORGANIZATION_ID) - ORGANIZATION (ID)
FACT WORK ORDER (Dim_Priority_ID) - PRIORITY (ID)
FACT WORK ORDER (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID)
FACT WORK ORDER (Dim_Project_ID) - PROJECT (ID)
FACT WORK ORDER (Dim_Reporting_Date_ID) - REPORTING DATE (ID)
FACT WORK ORDER (Dim_Service_Contract_ID) - SERVICE CONTRACT (ID)
FACT WORK ORDER (DIM_SITE_ID) - SITE (ID)
FACT WORK ORDER (Dim_Sla_Order_No) - SLA ORDER (ID)
FACT WORK ORDER (Dim_Sub_Project_ID) - SUB PROJECT (ID)
FACT WORK ORDER (Dim_Supplier_ID) - SUPPLIER (ID)
FACT WORK ORDER (Dim_Symptom_ID) - SYMPTOM (ID)
FACT WORK ORDER (Dim_Vim_Serial_ID) - VIM SERIAL (ID)
FACT WORK ORDER (Dim_Wo_Connection_Type_ID) - WT CONNECTION TYPE ACTUAL (ID)
FACT WORK ORDER (DIM_WORK_ORDER_ID) - WORK ORDER (ID)
FACT WORK ORDER (DIM_WORK_TYPE_CATEGORY_ID) - WORK TYPE CATEGORY (ID)
FACT WORK ORDER (DIM_WORK_TYPE_ID) - WORK TYPE (ID)
FACT WORK TASK (Dim_Act_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID)
FACT WORK TASK (Dim_Activity_ID) - ACTIVITY (ID)
FACT WORK TASK (Dim_Cancel_Task_Cause_ID) - CANCEL TASK CAUSE (ID)
FACT WORK TASK (Dim_Cause_ID) - CAUSE (ID)
FACT WORK TASK (Dim_Class_ID) - CLASS (ID)
FACT WORK TASK (Dim_Company_ID) - COMPANY (ID)
FACT WORK TASK (Dim_Customer_ID) - CUSTOMER (ID)
FACT WORK TASK (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID)
FACT WORK TASK (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID)
FACT WORK TASK (Dim_Date_Reported_ID) - REPORTING DATE (ID)
FACT WORK TASK (Dim_Discovery_ID) - DISCOVERY (ID)
FACT WORK TASK (Dim_Event_ID) - EVENT (ID)
FACT WORK TASK (Dim_Failing_Component_ID) - FAILING COMPONENT (ID)
FACT WORK TASK (Dim_Fault_Type_ID) - FAULT TYPE (ID)
FACT WORK TASK (Dim_Item_Class_Function_ID) - ITEM CLASS FUNCTION (ID)
FACT WORK TASK (Dim_Item_Class_ID) - ITEM CLASS (ID)
FACT WORK TASK (Dim_Item_Class_Source_ID) - ITEM CLASS SOURCE (ID)
FACT WORK TASK (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID)
FACT WORK TASK (Dim_Organization_ID) - ORGANIZATION (ID)
FACT WORK TASK (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID)
FACT WORK TASK (Dim_PM_Group_ID) - PM GROUP (ID)
FACT WORK TASK (Dim_Priority_ID) - PRIORITY (ID)
FACT WORK TASK (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID)
FACT WORK TASK (Dim_Reported_Object_Site_ID) - REPORTED OBJECT SITE (ID)
FACT WORK TASK (Dim_Service_Contract_ID) - SERVICE CONTRACT (ID)
FACT WORK TASK (Dim_Site_ID) - SITE (ID)
FACT WORK TASK (Dim_Site_ID) - SOURCE SITE (ID)
FACT WORK TASK (Dim_SLA_ORDER_Line_ID) - SLA ORDER LINE (ID)
FACT WORK TASK (Dim_Source_Connection_ID) - SOURCE CONNECTION (ID)
FACT WORK TASK (Dim_Supplier_ID) - SUPPLIER (ID)
FACT WORK TASK (Dim_Symptom_ID) - SYMPTOM (ID)
FACT WORK TASK (Dim_Wo_Connection_Type_ID) - WO CONNECTION TYPE (ID)
FACT WORK TASK (Dim_Work_Order_ID) - WORK ORDER (ID)
FACT WORK TASK (Dim_Work_Stage_ID) - WORK STAGE (ID)
FACT WORK TASK (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID)
FACT WORK TASK (Dim_Work_Type_ID) - WORK TYPE (ID)
WO BUDGET (Dim_Activity_ID) - ACTIVITY (ID)
WO BUDGET (Dim_Company_ID) - COMPANY (ID)
WO BUDGET (Dim_Compatible_Unit_ID) - COMPATIBLE UNIT (ID)
WO BUDGET (Dim_Cost_Type_ID) - WO COST TYPE (ID)
WO BUDGET (Dim_Customer_ID) - CUSTOMER (ID)
WO BUDGET (Dim_Date_Earliest_Start_ID) - REQUIRED START DATE (ID)
WO BUDGET (Dim_Date_Required_Compl_ID) - REQUIRED FINISH DATE (ID)
WO BUDGET (Dim_Discovery_ID) - DISCOVERY (ID)
WO BUDGET (Dim_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID)
WO BUDGET (Dim_Linear_Asset_ID) - LINEAR ASSET (ID)
WO BUDGET (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID)
WO BUDGET (Dim_Organization_ID) - ORGANIZATION (ID)
WO BUDGET (Dim_Priority_ID) - PRIORITY (ID)
WO BUDGET (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID)
WO BUDGET (Dim_Project_ID) - PROJECT (ID)
WO BUDGET (Dim_Reporting_Date_ID) - REPORTING DATE (ID)
WO BUDGET (Dim_Site_ID) - SITE (ID)
WO BUDGET (Dim_Sub_Project_ID) - SUB PROJECT (ID)
WO BUDGET (Dim_Supplier_ID) - SUPPLIER (ID)
WO BUDGET (Dim_Symptom_ID) - SYMPTOM (ID)
WO BUDGET (Dim_Vim_Serial_ID) - VIM SERIAL (ID)
WO BUDGET (Dim_Wo_Connection_Type_ID) - WO CONNECTION TYPE (ID)
WO BUDGET (Dim_Work_Order_ID) - WORK ORDER (ID)
WO BUDGET (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID)
WO BUDGET (Dim_Work_Type_ID) - WORK TYPE (ID)
WORK TASK ACTUALS COST (Dim_Act_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID)
WORK TASK ACTUALS COST (Dim_Activity_ID) - ACTIVITY (ID)
WORK TASK ACTUALS COST (Dim_Cancel_Task_Cause_ID) - CANCEL TASK CAUSE (ID)
WORK TASK ACTUALS COST (Dim_Cause_ID) - CAUSE (ID)
WORK TASK ACTUALS COST (Dim_Class_ID) - CLASS (ID)
WORK TASK ACTUALS COST (Dim_Company_ID) - COMPANY (ID)
WORK TASK ACTUALS COST (Dim_Customer_ID) - CUSTOMER (ID)
WORK TASK ACTUALS COST (Dim_Date_Actual_Compl_ID) - ACTUAL FINISH DATE (ID)
WORK TASK ACTUALS COST (Dim_Date_Actual_Start_ID) - ACTUAL START DATE (ID)
WORK TASK ACTUALS COST (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID)
WORK TASK ACTUALS COST (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID)
WORK TASK ACTUALS COST (Dim_Date_Reported_ID) - REPORTING DATE (ID)
WORK TASK ACTUALS COST (Dim_Discovery_ID) - DISCOVERY (ID)
WORK TASK ACTUALS COST (Dim_Event_ID) - EVENT (ID)
WORK TASK ACTUALS COST (Dim_Failing_Component_ID) - FAILING COMPONENT (ID)
WORK TASK ACTUALS COST (Dim_Fault_Type_ID) - FAULT TYPE (ID)
WORK TASK ACTUALS COST (Dim_Item_Class_Function_ID) - ITEM CLASS FUNCTION (ID)
WORK TASK ACTUALS COST (Dim_Item_Class_ID) - ITEM CLASS (ID)
WORK TASK ACTUALS COST (Dim_Item_Class_Source_ID) - ITEM CLASS SOURCE (ID)
WORK TASK ACTUALS COST (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID)
WORK TASK ACTUALS COST (Dim_Organization_ID) - ORGANIZATION (ID)
WORK TASK ACTUALS COST (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID)
WORK TASK ACTUALS COST (Dim_PM_Group_ID) - PM GROUP (ID)
WORK TASK ACTUALS COST (Dim_Priority_ID) - PRIORITY (ID)
WORK TASK ACTUALS COST (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID)
WORK TASK ACTUALS COST (Dim_Project_ID) - PROJECT (ID)
WORK TASK ACTUALS COST (Dim_Reported_Object_Site_ID) - REPORTED OBJECT SITE (ID)
WORK TASK ACTUALS COST (Dim_Service_Contract_Line_ID) - SERVICE CONTRACT (ID)
WORK TASK ACTUALS COST (Dim_Site_ID) - SITE (ID)
WORK TASK ACTUALS COST (Dim_Source_Connection_ID) - SOURCE CONNECTION (ID)
WORK TASK ACTUALS COST (Dim_Source_Object_ID) - SOURCE OBJECT (ID)
WORK TASK ACTUALS COST (Dim_Sub_Project_ID) - SUB PROJECT (ID)
WORK TASK ACTUALS COST (Dim_Supplier_ID) - SUPPLIER (ID)
WORK TASK ACTUALS COST (Dim_Symptom_ID) - SYMPTOM (ID)
WORK TASK ACTUALS COST (Dim_Wo_Connection_Type_ID) - WT CONNECTION TYPE ACTUAL (ID)
WORK TASK ACTUALS COST (Dim_Work_Order_ID) - WORK ORDER (ID)
WORK TASK ACTUALS COST (Dim_Work_Stage_ID) - WORK STAGE (ID)
WORK TASK ACTUALS COST (Dim_Work_Task_ID) - WORK TASK (ID)
WORK TASK ACTUALS COST (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID)
WORK TASK ACTUALS COST (Dim_Work_Type_ID) - WORK TYPE (ID)
WORK TASK ACTUALS SALES (Dim_Act_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID)
WORK TASK ACTUALS SALES (Dim_Act_Equipment_Object_ID) - REPORTED EQUIPMENT OBJECT (ID)
WORK TASK ACTUALS SALES (Dim_Activity_ID) - ACTIVITY (ID)
WORK TASK ACTUALS SALES (Dim_Cancel_Task_Cause_ID) - CANCEL TASK CAUSE (ID)
WORK TASK ACTUALS SALES (Dim_Cause_ID) - CAUSE (ID)
WORK TASK ACTUALS SALES (Dim_Class_ID) - CLASS (ID)
WORK TASK ACTUALS SALES (Dim_Company_ID) - COMPANY (ID)
WORK TASK ACTUALS SALES (Dim_Customer_ID) - CUSTOMER (ID)
WORK TASK ACTUALS SALES (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID)
WORK TASK ACTUALS SALES (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID)
WORK TASK ACTUALS SALES (Dim_Date_Reported_ID) - REPORTING DATE (ID)
WORK TASK ACTUALS SALES (Dim_Date_Reported_ID) - SLA LATEST FINISH DATE (ID)
WORK TASK ACTUALS SALES (Dim_Date_Reported_ID) - SLA LATEST START DATE (ID)
WORK TASK ACTUALS SALES (Dim_Discovery_ID) - DISCOVERY (ID)
WORK TASK ACTUALS SALES (Dim_Event_ID) - EVENT (ID)
WORK TASK ACTUALS SALES (Dim_Failing_Component_ID) - FAILING COMPONENT (ID)
WORK TASK ACTUALS SALES (Dim_Fault_Type_ID) - FAULT TYPE (ID)
WORK TASK ACTUALS SALES (Dim_Item_Class_Function_ID) - ITEM CLASS FUNCTION (ID)
WORK TASK ACTUALS SALES (Dim_Item_Class_ID) - ITEM CLASS (ID)
WORK TASK ACTUALS SALES (Dim_Item_Class_Source_ID) - ITEM CLASS SOURCE (ID)
WORK TASK ACTUALS SALES (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID)
WORK TASK ACTUALS SALES (Dim_Organization_ID) - ORGANIZATION (ID)
WORK TASK ACTUALS SALES (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID)
WORK TASK ACTUALS SALES (Dim_PM_Group_ID) - PM GROUP (ID)
WORK TASK ACTUALS SALES (Dim_Priority_ID) - PRIORITY (ID)
WORK TASK ACTUALS SALES (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID)
WORK TASK ACTUALS SALES (Dim_Reported_Object_Site_ID) - REPORTED OBJECT SITE (ID)
WORK TASK ACTUALS SALES (Dim_Service_Contract_ID) - SERVICE CONTRACT (ID)
WORK TASK ACTUALS SALES (Dim_Site_ID) - SITE (ID)
WORK TASK ACTUALS SALES (Dim_Site_ID) - SOURCE SITE (ID)
WORK TASK ACTUALS SALES (Dim_Source_Connection_ID) - SOURCE CONNECTION (ID)
WORK TASK ACTUALS SALES (Dim_Source_Object_ID) - SOURCE OBJECT (ID)
WORK TASK ACTUALS SALES (Dim_Supplier_ID) - SUPPLIER (ID)
WORK TASK ACTUALS SALES (Dim_Symptom_ID) - SYMPTOM (ID)
WORK TASK ACTUALS SALES (Dim_Wo_Connection_Type_ID) - WO CONNECTION TYPE (ID)
WORK TASK ACTUALS SALES (Dim_Wo_Connection_Type_ID) - WT CONNECTION TYPE ACTUAL (ID)
WORK TASK ACTUALS SALES (Dim_Work_Order_ID) - WORK ORDER (ID)
WORK TASK ACTUALS SALES (Dim_Work_Stage_ID) - WORK STAGE (ID)
WORK TASK ACTUALS SALES (Dim_Work_Task_ID) - WORK TASK (ID)
WORK TASK ACTUALS SALES (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID)
WORK TASK ACTUALS SALES (Dim_Work_Type_ID) - WORK TYPE (ID)
WORK TASK PLANNED (Dim_Activity_ID) - ACTIVITY (ID)
WORK TASK PLANNED (Dim_Cause_ID) - CAUSE (ID)
WORK TASK PLANNED (Dim_Class_ID) - CLASS (ID)
WORK TASK PLANNED (Dim_Company_ID) - COMPANY (ID)
WORK TASK PLANNED (Dim_Cost_Type_ID) - WO COST TYPE (ID)
WORK TASK PLANNED (Dim_Customer_ID) - CUSTOMER (ID)
WORK TASK PLANNED (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID)
WORK TASK PLANNED (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID)
WORK TASK PLANNED (Dim_Discovery_ID) - DISCOVERY (ID)
WORK TASK PLANNED (Dim_Event_ID) - EVENT (ID)
WORK TASK PLANNED (Dim_Fault_Type_ID) - FAULT TYPE (ID)
WORK TASK PLANNED (Dim_Linear_Asset_ID) - LINEAR ASSET (ID)
WORK TASK PLANNED (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID)
WORK TASK PLANNED (Dim_Organization_ID) - ORGANIZATION (ID)
WORK TASK PLANNED (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID)
WORK TASK PLANNED (Dim_Priority_ID) - PRIORITY (ID)
WORK TASK PLANNED (Dim_Proj_Program_Id) - PROJECT PROGRAM (ID)
WORK TASK PLANNED (Dim_Reporting_Date_ID) - REPORTING DATE (ID)
WORK TASK PLANNED (Dim_Site_ID) - SITE (ID)
WORK TASK PLANNED (Dim_Source_Connection_ID) - SOURCE CONNECTION (ID)
WORK TASK PLANNED (Dim_Sub_Project_ID) - SUB PROJECT (ID)
WORK TASK PLANNED (Dim_Supplier_ID) - SUPPLIER (ID)
WORK TASK PLANNED (Dim_Symptom_ID) - SYMPTOM (ID)
WORK TASK PLANNED (Dim_Vim_Serial_ID) - VIM SERIAL (ID)
WORK TASK PLANNED (Dim_Work_Order_ID) - WORK ORDER (ID)
WORK TASK PLANNED (Dim_Work_Type_Category_ID) - WORK TYPE CATEGORY (ID)
WORK TASK PLANNED (Dim_Work_Type_ID) - WORK TYPE (ID)
WORK TASK POSTINGS (Dim_Account_ID) - ACCOUNT (ID)
WORK TASK POSTINGS (Dim_Activity_ID) - ACTIVITY (ID)
WORK TASK POSTINGS (Dim_Cancel_Task_Cause_ID) - CANCEL TASK CAUSE (ID)
WORK TASK POSTINGS (Dim_Cause_ID) - CAUSE (ID)
WORK TASK POSTINGS (Dim_Class_ID) - CLASS (ID)
WORK TASK POSTINGS (Dim_Code_B_ID) - CODE B (ID)
WORK TASK POSTINGS (Dim_Code_C_ID) - CODE C (ID)
WORK TASK POSTINGS (Dim_Code_D_ID) - CODE D (ID)
WORK TASK POSTINGS (Dim_Code_E_ID) - CODE E (ID)
WORK TASK POSTINGS (Dim_Code_F_ID) - CODE F (ID)
WORK TASK POSTINGS (Dim_Code_G_ID) - CODE G (ID)
WORK TASK POSTINGS (Dim_Code_H_ID) - CODE H (ID)
WORK TASK POSTINGS (Dim_Code_I_ID) - CODE I (ID)
WORK TASK POSTINGS (Dim_Code_J_ID) - CODE J (ID)
WORK TASK POSTINGS (Dim_Company_ID) - COMPANY (ID)
WORK TASK POSTINGS (Dim_Customer_ID) - CUSTOMER (ID)
WORK TASK POSTINGS (Dim_Date_Actual_Compl_ID) - ACTUAL FINISH DATE (ID)
WORK TASK POSTINGS (Dim_Date_Actual_Start_ID) - ACTUAL START DATE (ID)
WORK TASK POSTINGS (Dim_Date_Earliest_Start_ID) - REQUIRED START DATE (ID)
WORK TASK POSTINGS (Dim_Date_Latest_Finish_ID) - REQUIRED FINISH DATE (ID)
WORK TASK POSTINGS (Dim_Date_Planned_Compl_ID) - PLANNED FINISH DATE (ID)
WORK TASK POSTINGS (Dim_Date_Planned_Start_ID) - PLANNED START DATE (ID)
WORK TASK POSTINGS (Dim_Date_SLA_Latest_Finish_ID) - SLA LATEST FINISH DATE (ID)
WORK TASK POSTINGS (Dim_Date_SLA_Latest_Start_Id) - SLA LATEST START DATE (ID)
WORK TASK POSTINGS (Dim_Discovery_ID) - DISCOVERY (ID)
WORK TASK POSTINGS (Dim_Equipment_Object_ID) - ACTUAL EQUIPMENT OBJECT (ID)
WORK TASK POSTINGS (Dim_Event_ID) - EVENT (ID)
WORK TASK POSTINGS (Dim_Failing_Component_ID) - FAILING COMPONENT (ID)
WORK TASK POSTINGS (Dim_Fault_Type_ID) - FAULT TYPE (ID)
WORK TASK POSTINGS (Dim_Item_Class_Function_ID) - ITEM CLASS FUNCTION (ID)
WORK TASK POSTINGS (Dim_Item_Class_ID) - ITEM CLASS (ID)
WORK TASK POSTINGS (Dim_Item_Class_Source_ID) - ITEM CLASS SOURCE (ID)
WORK TASK POSTINGS (Dim_Item_Class_Source_ID) - SOURCE CONNECTION (ID)
WORK TASK POSTINGS (Dim_Operational_Status_ID) - OPERATIONAL STATUS (ID)
WORK TASK POSTINGS (Dim_Organisation_Site_ID) - ORGANIZATION SITE (ID)
WORK TASK POSTINGS (Dim_Organization_ID) - ORGANIZATION (ID)
WORK TASK POSTINGS (Dim_Performed_Actions_ID) - PERFORMED ACTION (ID)
WORK TASK POSTINGS (Dim_PM_Group_ID) - PM GROUP (ID)
WORK TASK POSTINGS (Dim_Posting_Type_ID) - TASK ACCOUNTING TYPE (ID)
WORK TASK POSTINGS (Dim_Priority_ID) - PRIORITY (ID)
WORK TASK POSTINGS (Dim_Proj_Program_ID) - PROJECT PROGRAM (ID)
WORK TASK POSTINGS (Dim_Project_ID) - PROJECT (ID)
WORK TASK POSTINGS (Dim_Rep_Mch_Ref_ID) - REPORTED EQUIPMENT OBJECT (ID)
WORK TASK POSTINGS (Dim_Reported_Object_Site_ID) - REPORTED OBJECT SITE (ID)
WORK TASK POSTINGS (Dim_Reporting_Date_Id) - REPORTING DATE (ID)
WORK TASK POSTINGS (Dim_Rpd_Company_Period_ID) - REPORTING PERIOD (Company-Date)
WORK TASK POSTINGS (Dim_Service_Contract_Line_ID) - SERVICE CONTRACT (ID)
WORK TASK POSTINGS (Dim_Site_ID) - SITE (ID)
WORK TASK POSTINGS (Dim_Source_Object_ID) - SOURCE OBJECT (ID)
WORK TASK POSTINGS (Dim_Source_Site_ID) - SOURCE SITE (ID)
WORK TASK POSTINGS (Dim_Sub_Project_ID) - SUB PROJECT (ID)
WORK TASK POSTINGS (Dim_Supplier_ID) - SUPPLIER (ID)
WORK TASK POSTINGS (Dim_Symptom_ID) - SYMPTOM (ID)
WORK TASK POSTINGS (Dim_Time_Type_ID) - TIME TYPE (ID)
WORK TASK POSTINGS (Dim_Transaction_Type_ID) - TRANSACTION TYPE (ID)
WORK TASK POSTINGS (Dim_Wo_Connection_Type_ID) - WO CONNECTION TYPE (ID)
WORK TASK POSTINGS (Dim_WO_Cost_Type_ID) - WO COST TYPE (ID)
WORK TASK POSTINGS (Dim_Work_Order_No_Id) - WORK ORDER (ID)
WORK TASK POSTINGS (Dim_Work_Stage_ID) - WORK STAGE (ID)
WORK TASK POSTINGS (Dim_Work_Task_Seq_ID) - WORK TASK (ID)
WORK TASK POSTINGS (Dim_Work_Type_Cat_ID) - WORK TYPE CATEGORY (ID)
WORK TASK POSTINGS (Dim_Work_Type_ID) - WORK TYPE (ID)
WORK TASK PLANNED (Dim_Criticality_ID) - CRITICALITY (ID)
ASSET HEALTH LEVEL (Level) - COLOR LEVEL (Description)
ASSET HEALTH (Asset Health Level) - COLOR LEVEL (Description)
ASSET HEALTH (Dim_Company_Id) - COMPANY (ID)
ASSET HEALTH (Dim_Site_Id) - SITE (ID)
WORK TASK ACTUALS COST (Dim_Site_ID) - ACTUAL OBJECT SITE (ID)
WORK TASK ACTUALS SALES (Dim_Site_ID) - ACTUAL OBJECT SITE (ID)
WORK TASK POSTINGS (Dim_Actual_Obj_Site_ID) - ACTUAL OBJECT SITE (ID)
ASSET HEALTH INDI HST (Dim_Asset_Id) - ASSET HEALTH DIMENSION (ID)
ASSET HEALTH (Dim_Asset_Id) - ASSET HEALTH DIMENSION (ID)
ASSET HEALTH HISTORY (Dim_Asset_Id) - ASSET HEALTH DIMENSION (ID)
ASSET HEALTH LEVEL (Dim_Asset_Type) - ASSET TYPE (ID)
ASSET HEALTH (Dim_Asset_Type) - ASSET TYPE (ID)
ASSET HEALTH INDICATOR (Dim_Asset_Type) - ASSET TYPE (ID)
ASSET HEALTH HISTORY (Dim_Asset_Type) - ASSET TYPE (ID)
ASSET HEALTH INDI HST (Dim_Asset_Health_Indicator) - ASSET HEALTH INDICATOR DIMENSION (ID)
ASSET HEALTH INDICATOR (ID) - ASSET HEALTH INDICATOR DIMENSION (ID)
ASSET HEALTH INDI HST (Dim_Asset_Type) - ASSET TYPE (ID)
Locations (ID) - ASSET HEALTH (Dim_Asset_Id)