Question
Table showing all activities preceding a specific activity
Hi,
How would I write a filter on a table to show all activities preceding a specific activity, along with the frequency?
Basically, what the process explorer fullscreen analysis shows.
Hi newlen,
you can create an OLAP table with the following input:
Dimension:
SOURCE("_CEL_P2P_ACTIVITIES_EN"."ACTIVITY_EN") (adapt table and column names)
KPI:
COUNT_TABLE("EKPO") (normal Case Count, adapt table name)
Component Filter:
FILTER TARGET("_CEL_P2P_ACTIVITIES_EN"."ACTIVITY_EN") = 'Receive Goods' (adapt table and column names, choose activity that you want to analyze)
Best regards,
MaxEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.