Please enable JavaScript to view this site.

 

 

The root cause analysis enables to find reasons for certain optimization potentials in single process instances. This MPM module is optional, when used it unlocks the analytics in the sheet Root Cause Analysis.

 

MPM root cause analysis provides a set of 13 optimization potentials that are by default derived due to the MPM algorithms. These are:

Low process governance

Long lead time / Long net lead time

Short lead time / Short net lead time

Long idle time / Long net idle time

Short idle time / Short net idle time

Long processing time / Long net processing time

Short processing time / Short net processing time

 

 

Furthermore, the Root Cause Analysis offers to analyze:

critical process behavior detected by process query (see section QueryBuilder),

optimization potential custom lead times (depending on the threshold value),

customized optimization potential (see section How to Perform Root Cause Analysis on Custom Process Optimization Potentials).

 

 

Performing root cause analysis in the MPM Template App requires only five simple steps:

 

1.Go to the root cause analysis tab.

 

2.Define dimensions and attributes for the root cause analysis by adapting the inline table RootCauseAnalysisDimensions. These dimensions will then be compared with the occurrence of optimization potentials and marked as optimization target or not.

a.Define in which table the dimensions are found. It is required that all dimensions you want to check with the RCA are together in one table which includes the CaseID. Set the table with this variable:

Let RCADimensionTable = 'CaseInformation';

 

b.Define which dimensions of the previously set table you want to analyze with the RCA. Therefore enter the fieldnames as rows in the following inline table:

 

The MPM Template App will look like the first code example, once filled in the inline table might look as the example below taken from the helpdesk process. The MPM root cause analysis does only account for dimensions, in the previously given table and it is important that this table includes the field CaseID.

 

 

RootCauseAnalysisDimensions:

load * inline

[

DimensionName

];

 

 

 

Helpdesk example:

 

RootCauseAnalysisDimensions:

load * inline

[

DimensionName

 

TicketType

 

Customer

 

Product

 

Workgroup

];

 

 

 

3.Select the default optimization potentials that should be considered.

The default optimization potentials are listed in the following inline table. To incorporate them into the root cause analysis, set the first colums "CalculateInRCA" to "y" for yes or "n" for no.

 

Warning

Adapt only the first column with "y" or "n", but do not change the entries in the inline table else-wise.

 

RootCauseAnalysisFlags:

load * inline 

[CalculateInRCA,

FlagName,

FlagTable,

ObservationType

n,

Low process governance,

CaseTimes_$(mvProcessDescription),

CaseID

y,

Long lead time,

CaseTimes_$(mvProcessDescription),

CaseID

y,

Short lead time,

CaseTimes_$(mvProcessDescription),

CaseID

n,

Long idle time,

CaseTimes_$(mvProcessDescription),

CaseID

n,

Short idle time,

CaseTimes_$(mvProcessDescription),

CaseID

n,

Long processing time,

CaseTimes_$(mvProcessDescription),

CaseID

n,

Short processing time,

CaseTimes_$(mvProcessDescription),

CaseID

n,

Long net lead time,

CaseTimes_$(mvProcessDescription),

CaseID

n,

Short net lead time,

CaseTimes_$(mvProcessDescription),

CaseID

n,

Long net processing time,

CaseTimes_$(mvProcessDescription),

CaseID

n,

Short net processing time,

CaseTimes_$(mvProcessDescription),

CaseID

n,

Long net idle time,

CaseTimes_$(mvProcessDescription),

CaseID

n,

Short net idle time,

CaseTimes_$(mvProcessDescription),

CaseID

];

 

 

 

 

 

4.Set the threshold for optimization of too fast or too slow cases

Define which percentage of cases will be analyzed regarding the time optimization potential.

To do so, perform the following steps:

a)Open the script tab "2A. Advanced Customization".

b)Set a value to the variable mvPercentageUpperTimeLimit which indicates the percentage of the slowest cases that are considered as optimization potential. The default value is 10%

Set mvPercentageUpperTimeLimit = 0.1;

 

c)Set a value to the variable mvPercentageLowerTimeLimit which indicated the percentage of the fastest cases that are considered as optimization potential. The default value is 10%

Set mvPercentageLowerTimeLimit = 0.1;

 

5.Set the threshold for optimization of the process governance

Define which percentage of cases will be analyzed regarding the process governance optimization potential.

d)Open the script tab "4. Conformance Checking".

b)Set the value, which indicates the maximum percentage of the happy path fitness that is considered as optimization potential. The default value is 80%. In this example, cases with less than 75% process governance are considered as optimization potential.

Set mvProcessGovernanceOptimizationThreshold = 0.75;

 

6.Decide with this variable if you want the RCA to only calculate relationships between optimization potentials and the process context for closed cases. This makes sense e.g. regarding lead times, because open processes will clearly have a shorter lead time and thus could misrepresent process contexts that trigger a high (or low) lead time. The default value is 0, which means that the relationship is calculated for all cases.

Let mvRCAForFinishedProcessOnly = 0;

 

7.Optional: Define critical process paths by queries to explain their occurrence.

By adding lines to this inline table, cases which follow the critical process variant will be marked and the reasons for this critical deviation will be extracted from the data. To do so, perform the following steps:

a)Open the MPM Extension QueryBuilder and define a critical process query.

b)Open the QueryBuilder in edit mode and copy paste the resulting process query to the first column "CriticalPathQuery".

c)Give it a unique and speaking name, as the name will be displayed as the problem description in the root cause analysis' front end.

d)If you do not want to employ this type of analysis, just delete the rows from the inline table.

 

[CriticalQueries_$(mvProcessDescription)]:

load * inline 

[

CriticalPathQuery,

FlagName

 

0-*102-*104-*99999999

Suspicious Path

];

 

 

 

8.Optional: Explain too long or too slow custom lead times by the root cause analysis by setting the variable mvCustomLeadTimeInRCA to "1". When set to "0", the root cause analysis will not derive reasons that have caused cases to have an extremely high or low custom lead time. The optimization potentials use the same threshold to determine optimizable cases as in step 4.

 

LET mvCustomLeadTimeInRCA = 1;

 

9.Lastly, the MPM root cause analysis will be called. You do not need to change anything here.

 

call  mw_perform_root_cause_analysis('$(mvProcessDescription)','$(mvCustomLeadTimeInRCA)','RootCauseAnalysisDimensions','RootCauseAnalysisFlags','$(RCADimensionTable)','CustomLeadTimes_$(mvProcessDescription)');

 

© by MEHRWERK GmbH