Skip to main content

I would like to create a KPI to determine the % of the confirmation date changes which were caused by a requested date change in the Order to Cash activity flow.

If the 2 events: Requested Date Change and Confirmed Date Change happened at the same time and with the same change number (which is stored in a separate column in the activity table), we assume the confirmed date change was caused by the requested date change.

What would be the best way to check for this? SOURCE? TARGET? ACTIVITY_LAG/LEAD?

Any ideas are appreciated.

 

Hi,

 

That's a case similar a bit to SoD use-cases, there's dedicated code samples and training for that.

In theory Activity_LAG/Lead could work, but I assume it won't be the best solution here.

 

Hope that piece of documentation will help: Segregation of Duties (celonis.com)

 

Best Regards,

Mateusz Dudek

Thanks Mateusz. I have actually checked that before asking the question but there was also another use case with the lag/lead functions so that's why I was not sure which one to use. In the end, I went with TARGET & SOURCE.

Reply


Terms & ConditionsCookie settings