Cube - Maintenance

Contents

Usage/Purpose

Main analysis scenarios are:

To see which dimensions that can be used with each fact in, for example Excel pivot analysis, see section Fact and Dimension Connections below.

Overview Facts

Cube Fact (DSV name) Measure Group Referenced Information Source BI Access View Access Type
FACT_WORK ORDER WORK ORDER FACT_WORK_ORDER FACT_WORK_ORDER_BI On Line
FACT_WO BUDGET_BI WO BUDGET FACT_WO_BUDGET FACT_WO_BUDGET_BI On Line
FACT_WO PLANNED_BI WO PLANNED FACT_WO_PLANNED FACT_WO_PLANNED_BI On Line
FACT_WORK TASK WORK TASK FACT_WORK_TASK FACT_WORK_TASK_BI On Line
FACT_WO_TASK_ACTUALS_COST_BI WORK TASK ACTUALS COST FACT_WO_TASK_ACTUALS_COST FACT_WO_TASK_ACTUALS_COST_BI On Line
FACT_WO_TASK_ACTUALS_SALES_BI WORK TASK ACTUALS SALES FACT_WO_TASK_ACTUALS_SALES FACT_WO_TASK_ACTUALS_SALES_BI On Line
FACT_JT_TASK_ACCOUNTING WORK TASK POSTINGS ACT_JT_TASK_ACCOUNTING ACT_JT_TASK_ACCOUNTING_BI On Line

Each measure in the facts is described in section Measures. Corresponding Information Sources are described below. Detalled infomation about Information Sources can be found in IFS Online Documentation.

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_WO_PLANNED
Work Order Planned Information Source is based on the planning lines for regarding work orders. It should mainly be used in conjunction with Work Order 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

 

Overview Dimensions

Cube Dimension Note
ACCOUNT  
ACTION  
ACTIVITY  
ACTUAL EQUIPMENT OBJECT  
ACTUAL FINISH DATE  
ACTUAL START DATE  
ACTUAL OBJECT SITE  
CANCEL TASK CAUSE  
CAUSE  
CLASS  
CODE B  
CODE C  
CODE D  
CODE E  
CODE F  
CODE G  
CODE H  
CODE I  
CODE J  
COMPANY  
COMPANY REPORTING PERIOD  
COMPATIBLE UNIT  
CREATED_DATE  
CRTICALITY  
CUSTOMER  
DISCOVERY  
EQUPIMENT OBJECT  
EVENT  
FAILING COMPONENT  
FAULT TYPE  
ITEM CLASS  
ITEM CLASS FUNCTION  
ITEM CLASS SOURCE  
LINEAR ASSET  
OPERATIONAL STATUS  
ORGANIZATION  
ORGANIZATION SITE  
PERFORMED ACTION  
PLANNED DATE  
PLANNED FINISH DATE  
PLANNED START DATE  
PM_GROUP  
PRIORITY  
PROJECT  
PROJECT PROGRAM  
REPORTED EQUIPMENT OBJECT  
REPORTED OBJECT SITE  
REPORTING CURRENCY  
REPORTING DATE  
REPORTING PERIOD Company Reporting Period
REQUIRED FINISH DATE  
REQUIRED START DATE  
SALES PART  
SERVICE CONTRACT  
SITE  
SLA ORDER  
SLA ORDER LINE  
SLA FINISH DATE  
SLA START DATE  
SOURCE CONNECTION  
SOURCE CONNECTION  
SOURCE SITE  

SUB PROJECT

  
SUPPLIER  
SYMPTOM  
TASK ACCOUNTING TYPE  
TIME TYPE  
TRANSACTION TYPE  
VIM SERIAL  
VOUCHER DATE  
WO BUDGET This is a cube-only dimension, i.e. not  supported by a standard dimension.
WO CONNECTION TYPE  
WO COST TYPE  
WO PLANNED This is a cube-only dimension, i.e. not  supported by a standard dimension.
WORK ORDER  
WORK_STAGE  
WORK TASK  
WORK TYPE  
WORK TYPE CATEGORY  
WO_TASK_ACTUALS_COST  
WO_TASK_ACTUALS_SALES This is a cube-only dimension, i.e. not  supported by a standard dimension.
WT_CONNECTION_TYPE_ACTUAL  
WT_CONNECTION_TYPE_REPORTED  

 

Configurations

The Maintenance cube 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.

Refer technical documentation for more information.

Limitations

The Maintenance cube is using the Company Reporting Period dimension, which means that it is necessary to create a specific Reporting Period Definition to be used by this cube. The created/selected identity must also be defined in the lookup configuration for the ETL process, using Source = 'Maintenance'.

The cube 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.

Refer technical documentation for more information.

Fact and Dimension Connections

The following picture shows how different facts in the cube are connected to the available dimensions.











 

Measures

General

Aggregation of measures is based on SUM if not explicitly noted.

Basic Measures

This sections describes the basic measures in the cube. These are either measures defined in the core Information Source or in the ETL process. The columns have the following meaning:

 

Measure Measure Group Core Measure ETL Measure Cube Measure Measure Expression Reporting Currency Measure Aggr. Method Note
Cost Amount Planned WO PLANNED YES NO NO NO NO SUM  
Qty to Invoice Planned WO PLANNED YES NO NO NO NO SUM  
Qty Planned WO PLANNED YES NO NO NO NO SUM  
Revenue Amount Planned WO PLANNED YES NO NO NO NO SUM  
WO PLANNED Count WO PLANNED NO NO YES NO NO COUNT  
Revenue Amount Planned RC WO PLANNED NO NO NO YES YES SUM  
Cost Amount Planned RC WO PLANNED NO NO NO YES YES SUM  
Cost Amount Budget WO BUDGET YES NO NO NO NO SUM  
Revenue Amount Budget WO BUDGET YES NO NO NO NO SUM  
WO BUDGET Count WO BUDGET NO NO YES NO NO COUNT  
Cost Amount Budget RC WO BUDGET NO NO NO YES YES SUM  
Revenue Amount Budget RC WO BUDGET NO NO NO YES YES SUM  
Qty Actual Sales WORK TASK ACTUALS  SALES YES NO NO NO NO SUM  
Qty To Invoice Actual WORK TASK ACTUALS  SALES YES NO NO NO NO SUM  
Base Prise WORK TASK ACTUALS  SALES YES NO NO NO NO Average of Children  
Sales Price WORK TASK ACTUALS  SALES YES NO NO NO NO Average of Children  
Discount WORK TASK ACTUALS  SALES YES NO NO NO NO Average of Children  
Revenue Amount Actual WORK TASK ACTUALS  SALES YES NO NO NO NO SUM Amt in Base Currency
Revenue Percent WORK TASK ACTUALS  SALES YES NO NO NO NO Average of Children  
Revenue Amount Actual Curr WORK TASK ACTUALS  SALES YES NO NO NO NO SUM  
Revenue Amount Actual RC WORK TASK ACTUALS  SALES NO NO NO YES YES SUM  
Markup WORK TASK ACTUALS  SALES YES NO NO NO NO Average of Children  
Work Task Actual Sales Count WORK TASK ACTUALS  SALES NO NO YES NO NO COUNT  
Cost Amount Actual WORK TASK ACTUALS COST YES NO NO NO NO SUM  
Qty Actual WORK TASK ACTUALS COST YES NO NO NO NO SUM  
Material Quantity Actual WORK TASK ACTUALS COST NO YES NO NO NO SUM  
Material Cost Amount Actual WORK TASK ACTUALS COST NO YES NO NO NO SUM  
Installation Cost Amount Actual WORK TASK ACTUALS COST NO YES NO NO NO SUM  
Installation Hours Actual WORK TASK ACTUALS COST NO YES NO NO NO SUM  
Preventive Cost Amount Actual WORK TASK ACTUALS COST NO YES NO NO NO SUM  
Preventive Hours Actual WORK TASK ACTUALS COST NO YES NO NO NO SUM  
Corrective Cost Amount Actual WORK TASK ACTUALS COST NO YES NO NO NO SUM  
Corrective Hours Actual WORK TASK ACTUALS COST NO YES NO NO NO SUM  
Modification Cost Amount Actual WORK TASK ACTUALS COST NO YES NO NO NO SUM  
Modification Hours Actual WORK TASK ACTUALS COST NO YES NO NO NO SUM  
Project Cost Amount Actual WORK TASK ACTUALS COST NO YES NO NO NO SUM  
Project Hours Actual WORK TASK ACTUALS COST NO YES NO NO NO SUM  
Service Cost Amount Actual WORK TASK ACTUALS COST NO YES NO NO NO SUM  
Service Hours Actual WORK TASK ACTUALS COST NO YES NO NO NO SUM  
Other Cost Amount Actual WORK TASK ACTUALS COST NO YES NO NO NO SUM  
Other Hours Actual WORK TASK ACTUALS COST NO YES NO NO NO SUM  
Cost Amount Actual RC WORK TASK ACTUALS  COST NO NO NO YES YES SUM  
Material Cost Amount Actual RC WORK TASK ACTUALS  COST NO NO NO YES YES SUM  
Preventive Cost Amount Actual RC WORK TASK ACTUALS  COST NO NO NO YES YES SUM  
Installation Cost Amount Actual RC WORK TASK ACTUALS  COST NO NO NO YES YES SUM  
Corrective Cost Amount Actual RC WORK TASK ACTUALS  COST NO NO NO YES YES SUM  
Modification Cost Amount Actual RC WORK TASK ACTUALS  COST NO NO NO YES YES SUM  
Project Cost Amount Actual RC WORK TASK ACTUALS  COST NO NO NO YES YES SUM  
Service Cost Amount Actual RC WORK TASK ACTUALS  COST NO NO NO YES YES SUM  
Other Cost Amount Actual RC WORK TASK ACTUALS  COST NO NO NO YES YES SUM  
Work Task Actuals Cost Count WORK TASK ACTUALS  COST NO NO YES NO NO COUNT  
Work Task Count WORK TASK YES NO NO NO NO SUM  
Elapsed Execution Time Sum WT WORK TASK YES NO NO NO NO SUM  
Elapsed Waiting Time Sum WT WORK TASK YES NO NO NO NO SUM  
Task Count WORK TASK YES NO NO NO NO SUM  
Late Actual vs Required Start Count WT WORK TASK YES NO NO NO NO SUM  
Late Actual vs Planned Start Count WT WORK TASK YES NO NO NO NO SUM  
Late Actual vs Planned Finish Count WT WORK TASK YES NO NO NO NO SUM  
Late Actual vs Late Start Count WT WORK TASK YES NO NO NO NO SUM  
Late Actual vs Fixed Start Count WT WORK TASK YES NO NO NO NO SUM  
Deviation Late Actual vs Planned Start Date Hours WT WORK TASK YES NO NO NO NO Average of Children  
Deviation Late Actual vs Planned Finish Date Hours WT WORK TASK YES NO NO NO NO Average of Children  
Deviation Late Actual vs Required Start Date Hours WT WORK TASK YES NO NO NO NO Average of Children  
Deviation Late Actual vs Required End Date Hours WT WORK TASK YES NO NO NO NO Average of Children  
Deviation Late Actual vs Late Start Date Hours WT WORK TASK YES NO NO NO NO Average of Children  
Deviation Late Actual vs Fixed Start Date Hours WT WORK TASK YES NO NO NO NO Average of Children  
Early Actual vs Required Start Count WT WORK TASK YES NO NO NO NO SUM  
Early Actual vs Required Finish Count WT WORK TASK YES NO NO NO NO SUM  
Early Actual vs Planned Start Count WT WORK TASK YES NO NO NO NO SUM  
Early Actual vs Planned Finish Count WT WORK TASK YES NO NO NO NO SUM  
Early Actual vs Late Start Count WT WORK TASK YES NO NO NO NO SUM  
Early Actual vs Fixed Start Count WT WORK TASK YES NO NO NO NO SUM  
Deviation Early Actual vs Planned Start Date Hours WT WORK TASK YES NO NO NO NO Average of Children  
Deviation Early Actual vs Planned Finish Date Hours WT WORK TASK YES NO NO NO NO Average of Children  
Deviation Early Actual vs Required Start Date Hours WT WORK TASK YES NO NO NO NO Average of Children  
Deviation Early Actual vs Required Finish Date Hours WT WORK TASK YES NO NO NO NO Average of Children  
Deviation Early Actual vs Late Start Date Hours WT WORK TASK YES NO NO NO NO Average of Children  
Deviation Early Actual vs Fixed Start Date Hours WT WORK TASK YES NO NO NO NO Average of Children  
Corrective Task Count WORK TASK NO NO NO YES NO SUM  
Preventive Task Count WORK TASK NO NO NO YES NO SUM  
Service Task Count WORK TASK NO NO NO YES NO SUM  
Installation Task Count WORK TASK NO NO NO YES NO SUM  
Modification Task Count WORK TASK NO NO NO YES NO SUM  
Other Task Count WORK TASK NO NO NO YES NO SUM  
Fault Task Count WORK TASK NO NO NO YES NO SUM  
Elapsed Execution Time Count WT WORK TASK YES NO NO NO NO SUM  
Elapsed Waiting Time Count WT WORK TASK YES NO NO NO NO SUM  
Cost Amount Actual WTP WORK TASK POSTINGS YES NO NO NO NO SUM  
Qty Actual WTP WORK TASK POSTINGS YES NO NO NO NO SUM  
Material Quantity Actual WTP WORK TASK POSTINGS NO YES NO NO NO SUM  
Material Cost Amount Actual WTP WORK TASK POSTINGS NO YES NO NO NO SUM  
Installation Cost Amount Actual WTP WORK TASK POSTINGS NO YES NO NO NO SUM  
Installation Hours Actual WTP WORK TASK POSTINGS NO YES NO NO NO SUM  
Preventive Cost Amount Actual WTP WORK TASK POSTINGS NO YES NO NO NO SUM  
Preventive Hours Actual WTP WORK TASK POSTINGS NO YES NO NO NO SUM  
Corrective Cost Amount Actual WTP WORK TASK POSTINGS NO YES NO NO NO SUM  
Corrective Hours Actual WTP WORK TASK POSTINGS NO YES NO NO NO SUM  
Modification Cost Amount Actual WTP WORK TASK POSTINGS NO YES NO NO NO SUM  
Modification Hours Actual WTP WORK TASK POSTINGS NO YES NO NO NO SUM  
Project Cost Amount Actual WTP WORK TASK POSTINGS NO YES NO NO NO SUM  
Project Hours Actual WTP WORK TASK POSTINGS NO YES NO NO NO SUM  
Service Cost Amount Actual WTP WORK TASK POSTINGS NO YES NO NO NO SUM  
Service Hours Actual WTP WORK TASK POSTINGS NO YES NO NO NO SUM  
Other Cost Amount Actual WTP WORK TASK POSTINGS NO YES NO NO NO SUM  
Other Hours Actual WTP WORK TASK POSTINGS NO YES NO NO NO SUM  
Cost Amount Actual  WTP RC WORK TASK POSTINGS NO NO NO YES YES SUM  
Material Cost Amount Actual WTP RC WORK TASK POSTINGS NO NO NO YES YES SUM  
Preventive Cost Amount Actual WTP RC WORK TASK POSTINGS NO NO NO YES YES SUM  
Installation Cost Amount Actual WTP RC WORK TASK POSTINGS NO NO NO YES YES SUM  
Corrective Cost Amount Actual WTP RC WORK TASK POSTINGS NO NO NO YES YES SUM  
Modification Cost Amount Actual WTP RC WORK TASK POSTINGS NO NO NO YES YES SUM  
Project Cost Amount Actual WTP RC WORK TASK POSTINGS NO NO NO YES YES SUM  
Service Cost Amount Actual WTP RC WORK TASK POSTINGS NO NO NO YES YES SUM  
Other Cost Amount Actual WTP RC WORK TASK POSTINGS NO NO NO YES YES SUM  
Work Order Count WORK ORDER YES NO NO NO NO SUM  
Fault Order Count WORK ORDER YES NO NO NO NO SUM  
Preventive Order Count WORK ORDER NO YES NO NO NO SUM  
Corrective Order Count WORK ORDER NO YES NO NO NO SUM  
Project Order Count WORK ORDER NO YES NO NO NO SUM  
Service Order Count WORK ORDER NO YES NO NO NO SUM  
MWT Sum WORK ORDER YES NO NO NO NO SUM Elapsed waiting time
MWT Count WORK ORDER NO NO YES NO NO COUNT NON-EMPTY Count of records where Elapsed waiting time differs from NULL
MTFS Sum WORK ORDER NO YES NO NO NO SUM Elapsed time to start
MTFS Count WORK ORDER NO NO YES NO NO COUNT NON-EMPTY Count of records where Elapsed time to start differs from NULL
MTFF Sum WORK ORDER NO YES NO NO NO SUM Elapsed time to finish
MTFF Count WORK ORDER NO NO YES NO NO COUNT NON-EMPTY Count of records where Elapsed time to finish differs from NULL
MTTR Sum WORK ORDER YES NO NO NO NO SUM Elapsed execution time
MTTR Count WORK ORDER NO NO YES NO NO COUNT NON-EMPTY Count of records where Elapsed execution time differs from NULL
Installation Order Count WORK ORDER NO YES NO NO NO SUM  
Modification Order Count WORK ORDER NO YES NO NO NO SUM  
Other Order Count WORK ORDER NO YES NO NO NO SUM  
Late Actual vs Planned Finish Count WORK ORDER YES NO NO NO NO SUM  
Late Actual vs Planned Start Count WORK ORDER YES NO NO NO NO SUM  
Late Actual vs Required Finish Count WORK ORDER YES NO NO NO NO SUM  
Late Actual vs Required Start Count WORK ORDER YES NO NO NO NO SUM  
Elapsed Time to Start WORK ORDER YES NO NO NO NO Average of Children  
Elapsed Execution Time WORK ORDER YES NO NO NO NO Average of Children  
Elapsed Waiting Time WORK ORDER YES NO NO NO NO Average of Children  
Elapsed Time to Complete WORK ORDER YES NO NO NO NO Average of Children  
Late Actual vs Late Start Count WORK ORDER YES NO NO NO NO SUM  
Early Actual vs Required Start Count WORK ORDER YES NO NO NO NO SUM  
Early Actual vs Required Finish Count WORK ORDER YES NO NO NO NO SUM  
Early Actual vs Planned Start Count WORK ORDER YES NO NO NO NO SUM  
Early Actual vs Planned Finish Count WORK ORDER YES NO NO NO NO SUM  
Early Actual vs Late Start Count WORK ORDER YES NO NO NO NO SUM  
Early Actual vs Fixed Start Count WORK ORDER YES NO NO NO NO SUM  
Deviation Early Actual vs Planned Start Date Hours WORK ORDER YES NO NO NO NO Average of Children  
Deviation Early Actual vs Planned Finish Date Hours WORK ORDER YES NO NO NO NO Average of Children  
Deviation Early Actual vs Required Start Date Hours WORK ORDER YES NO NO NO NO Average of Children  
Deviation Early Actual vs Required Finish Date Hours WORK ORDER YES NO NO NO NO Average of Children  
Deviation Early Actual vs Late Start Date Hours WORK ORDER YES NO NO NO NO Average of Children  
Deviation Early Actual vs Fixed Start Date Hours WORK ORDER YES NO NO NO NO Average of Children  
Deviation Late Actual vs Late Start Date Hours WORK ORDER YES NO NO NO NO Average of Children  
Deviation Late Actual vs Fixed Start Date Hours WORK ORDER YES NO NO NO NO Average of Children  
Deviation Late Actual vs Planned Start Date Hours WORK ORDER YES NO NO NO NO Average of Children  
Deviation Late Actual vs Planned Finish Date Hours WORK ORDER YES NO NO NO NO Average of Children  
Deviation Late Actual vs Required Start Date Hours WORK ORDER YES NO NO NO NO Average of Children  
Deviation Late Actual vs Required End Date Hours WORK ORDER YES NO NO NO NO Average of Children  
                 
Number Of Days Time NO NO YES NO NO COUNT NON-EMPTY count of non-empty values
Currency Rate Reporting Currency Rate YES YES NO NO NO SUM Currency rate used to calculate amounts to reporting currency.
The core measure is modified in ETL

Calculated Measures

Calculated measures are in the cube calculated with respect to other measures. The table below defines the general meaning/definition of each calculated measure.

Measure Meaning Note
<work_type_cat> Hours Rate %

 		 <work_type_cat>  Hours Actual / Total Hours Actual

e.g. Service Hours Rate % = Service Hours Actual / Total Hours Actual		 <work_type_cat> is one of: Service, Project, Preventive, Corrective, Installation, Modification, Other
<work_type_cat> Cost Amount Rate % <work_type_cat> Cost Amount Actual / Cost Amount Actual

e.g. Service Cost Amount Actual % = Service Cost Amount Actual / / Cost Amount Actual		 <work_type_cat> is one of: Service, Project, Preventive, Corrective, Installation, Modification, Other
<work_type_cat2> Rate % <work_type_cat2> Order Count  / Work Order Count

e.g. Project Rate % = Project Order Count / Work Order Count		 <work_type_cat2> is one of: Service, Project, Preventive, Corrective, Installation, Modification, Other, Fault
Mean Waiting Time Work Hours MWT Sum / MWT Count  
Mean Waiting Time Work Days (MWT Sum / 8) / MWT Count  
Mean Waiting Time Work Minutes (MWT Sum * 60) / MWT Count  
Mean Time For Start Work Hours MTFS Sum / MTFS Count  
Mean Time For Start Work Days (MTFS Sum / 8) / MTFS Count  
Mean Time For Start Work Minutes (MTFS Sum * 60) / MTFS Count  
Mean Time For Finish Work Hours MTFF Sum / MTFF Count  
Mean Time For Finish Work Days (MTFF Sum / 8) / MTFF Count  
Mean Time For Finish Work Minutes (MTFF Sum * 60) / MTFF Count  
Mean Time To Repair Work Hours MTTR Sum / MTTR Count  
Mean Time To Repair Work Days (MTTR Sum / 8) / MTTR Count  
Mean Time To Repair Work Minutes (MTTR Sum * 60) / MTTR Count  
Mean Time Between Failure Days Number Of Days / Corrective Order Count  
Mean Time Between Failure Hours (Number Of Days * 24) / Corrective Order Count  
Mean Time Between Failure Minutes (Number Of Days * 24*60) / Corrective Order Count  

Time Based Measures

Time based measures are calculated in the cube with respect to other measures. The table below defines the meaning/definition of  the different time measures. These measures need to be used with a specific time dimension defined in the table below.

Measure Meaning
YTD Year to Date
Aggregated value for current month in current  year. E.g. for period 201210 Ytd represents sum of periods 201201-201210.
Based on [REPORTING_DATE].[RepDateMFHy]
R12 Rolling 12 (Completed) Moths
For a given period, the sum all months from one year back up to the previous month. E.g. Rolling 12 for 201210 is the sum of months 201110 - 201209
Based on [REPORTING_DATE].[RepDateMFHy]
PY Previous Year
The value of the corresponding month one year back. E.g. for month 201210, the value of month 201110.
Based on [REPORTING_DATE].[RepDateMFHy]
YTD PY Year to Date Previous Year
Aggregated value for corresponding month one year back. E.g. for month 201210 YTD Previous Year represents sum of months 201101-201110.
Based on [REPORTING_DATE].[RepDateMFHy]
R12 PY Rolling 12 (Completed) Months Previous Year
For a given month, first going one year back, then taking the sum of all months from one (more) year back up to the previous month. E.g. for month 201210 the sum of month 201010-201109
Based on [REPORTING_DATE].[RepDateMFHy]

 

Included Example Reports and Dashboards

This section lists dashboards and reports in the example content for the BI Analysis Package that is using this cube:

UI Name Type
Maintenance Excel Dashboard
Maintenance Analysis Power BI Report

Required Components

The BI specific and also related core components listed in this section are required, i.e. they must along with other dependent components, be part of the customer installation to successfully use this cube.

NOTE that only directly used components are listed. Each such component can have its own list of dependent components. Please refer to the Component Deployment Profile File for each component to get the full picture

Component Type Component Name Product
BISEDI BI BI Services Dimensions Business Intelligence
APTOOL BI Common scripts and utilities, BI Anapac Business Intelligence
APPSDI BI Application Services Analysis Package Dimension Business Intelligence
ENTEDI BI Enterprise Analysis Package Dimensions Business Intelligence
ACCRDI BI Accounting Rules Analysis Package Dimensions Business Intelligence
ACCRFT BI Accounting Rules Analysis Package Fact Business Intelligence
PROJDI BI Project Analysis Package Dimensions Business Intelligence
MSCODI BI Maintenance Common Analysis Package Dimensions Business Intelligence
PCMSDI BI PCM Service Contract Info BI Anapac Dimensions Business Intelligence
EQUIDI BI Equipment Analysis Package Dimensions Business Intelligence
MPCCDI BI Gen Inventory and Distr BI Anapac Dimensions Business Intelligence
ORDEDI BI Customer Orders Analysis Package Dimensions Business Intelligence
WODI BI Work Order BI Anapac Dimensions Business Intelligence
WOFT BI Work Order BI Anapac Facts Business Intelligence
WOANAC BI Work Order Analysis Cube Business Intelligence
ENTERP CORE Enterprise Financials
ACCRUL CORE Accounting Rules Financials
PROJ CORE Project Projects
MSCOM CORE Maintenance Common Service and Asset
WO CORE Work Order Service and Asset
PCMSCI CORE PCM Service Contract Information Service and Asset
EQUIP CORE Equipment Service and Asset
PM CORE Preventive and Corrective Maintenance Service and Asset
MPCCOM CORE General Inventory and Distribution Supply Chain
ORDER CORE Customer Order Supply Chain

Note: BI Component WOANAC