I’d like to create a cluster in form of a OLAP table in Celonis in which I can select the right process, but also those ID’s that go wrong through the process.
I have problems with the coding
Now something about the Process:
My process looks like f.ex.
Activity A Start–>Activity B -->Activity C -->Activity D -->Activity E–>Activity F END
For our department activity C and activity E is important. The other activities can be neglected.
The right process is when activity C comes first and activity E comes later, not the other way around.
The wrong process is,…
- when activity E comes first and activity C comes later, exactly the wrong way round,
- if activity E is completely missing,
I think I need something like this, but it is not yet thought through to the end
WHEN PROCESS EQUALS ‘Activity C’ TO ANY TO ‘Activity E’ --the order is still missing here
THEN ‘right process’
WHEN MATCH_ACTIVITIES(NODE[‘Activity C’] EXCLUDING[‘Activity E’])
OR PROCESS EQUALS ‘Activity E’ TO ANY TO ‘Activity C’ --the order is still missing here
THEN ‘wrong process’
ELSE ‘’ END)
can anyone help?