Hello All,
Hope you all are doing well
I want to know that is it possible to create a filter of below mentioned condition:
I am working on an event log of "purchase to pay", I wanted to know how to create a filter or calculated field to find out which resource is performing "Create Purchase Order" and "Pay Invoice" both.
I want to find out which resource is performing both the activities.
Please suggest if it is possible.
Your guidance would be much helpful.
Hi,
you need to do the calculation on a case basis for this reason, you need to pull-up the fields first.
I just created this calculation as an example. You can replace the fields like user for ressources and the names of the activities you are looking for and test it out.
CASE WHEN (
PU_ANY("_ARIS.Case", "_ARIS.Activity","Activity"."User","_ARIS.Activity"."Activity Name"='Create iDOC') =
PU_ANY("_ARIS.Case", "_ARIS.Activity","Activity"."User","_ARIS.Activity"."Activity Name"='Perform payment clearing'))
THEN PU_ANY("_ARIS.Case", "_ARIS.Activity","Activity"."User","_ARIS.Activity"."Activity Name"='Create iDOC')
ELSE NULL_TEXTBR
Martin
Hi,
you need to do the calculation on a case basis for this reason, you need to pull-up the fields first.
I just created this calculation as an example. You can replace the fields like user for ressources and the names of the activities you are looking for and test it out.
CASE WHEN (
PU_ANY("_ARIS.Case", "_ARIS.Activity","Activity"."User","_ARIS.Activity"."Activity Name"='Create iDOC') =
PU_ANY("_ARIS.Case", "_ARIS.Activity","Activity"."User","_ARIS.Activity"."Activity Name"='Perform payment clearing'))
THEN PU_ANY("_ARIS.Case", "_ARIS.Activity","Activity"."User","_ARIS.Activity"."Activity Name"='Create iDOC')
ELSE NULL_TEXTBR
Martin