For the sake of performance analysis, I want to create an OLAP table to cover the following aspects of a certain part of a process (Activity 1 -> Activity 2):
|Performer||Task||Throughput time, days||Percentage from a total workload|
There are a number of encountered problems however.
First, a standard THT KPI formula calculates only a difference between FIRST / LAST occurrences of an activity, thus it does not work for measuring time strictly between two activities taking into account all rework and process deviations (like Activity 1 -> Activity 3 -> Activity 4 -> Activity 2 ).
To overcome this issue, I used SOURCE / TARGET function, and it works when I just calculate the THT KPI only, but I have not managed to add other dimensions in the table (“no common parent between tables could be found”).
Second, to determine the ratio of a specific task among all of other tasks I – again - need to clean the number of cases as it turned out with throughput time (only cases witch follow direct sequence between Activities A to B can be taken into consideration).
Can anybody please give me some advice around this? What is important is to achieve the overall aim that is to provide information on performance efficiency (number of tasks and throughput time in relation to performers).
I am on Celonis 4.4 if that matters.