Component Filter: Crop Process

Hi,

I’d like to create a component filter to filter a dashboard sheet and its KPIs for a Subprocess.
E.g. our KPI “Touchless Order Rate” should only be calculated for the subprocess “process start” to “create delivery”.
I can get the right result, if I use the crop selection but I want to have this as a component filter.

Can anyone help me with the right PQL filter formula?

Thanks ,
Carina

Hi Carina,

you can try to use the following Filter. It will filter for the Subprocess that starts with the specified activity A and ends with a defined activity B.

FILTER PU_FIRST ( “Case Table”, “Activity Table”.“Column Activity Name” ) = ‘Activity A’ AND
PU_LAST ( “Case Table”, “Activity Table”.“Column Activity Name” ) = ‘Activity B’

If you need further support, feel free to reach out to us!

Best,

Justin

Hi Justin,

thank you, it worked!

Best regards,
Carina

Hi Justin,
I have an other question.

What is the right code to use this as a component filter?
image
I know, the filter starts like this:
FILTER PU_FIRST ( “VBAP”, “_CEL_O2C_ACTIVITIES”.“ACTIVITY_EN”) = ‘AV: Create Invoice’ AND ?
I don’t know how I get the “process end”.

Thank you!

Best regards,
Carina

Hi @CarinaDamke,

as far as I understand your issue correctly, you would like to rebuild the Crop Activities Between Filter. In this case you have to use CALC_CROP. In your case you would apply this function as follows:

FILTER
CASE
WHEN CALC_CROP (FIRST_OCCURRENCE [ ‘STARTACTIVITY’ ] TO CASE_END,
CASE
WHEN “Activity Table”.“Activity Column” = ‘Your Activity’
THEN ‘STARTACTIVITY’
ELSE “Activity Table”.“Activity Column” END
) = 1
THEN ‘Crop’
ELSE NULL
END
= ‘Crop’

Hopefully, that will solve your issue. Otherwise, please feel free to reach out to us again!

PS: As this is a new topic, it would be great if you would open a new topic in this category next time. That would make it as easy as possible for everybody else to find already answered issues.

Best,

Justin

Dear @j.stegmaier I have applied this proposed formula as filter in the process explorer, but it didnt crop the activities, I still see activities that occured before step ‘Sales Order Released’.
When I apply this to OLAP table, it seems to work. Is there anything additional for process explorer that needs to be done?
Thank you.
FILTER
CASE
WHEN CALC_CROP (FIRST_OCCURRENCE [ ‘STARTACTIVITY’ ] TO CASE_END,
CASE
WHEN “_CEL_O2C_ACTIVITIES”.“ACTIVITY_EN” = ‘Sales Order Released’
THEN ‘STARTACTIVITY’
ELSE NULL END
) = 1
THEN ‘Crop’
ELSE NULL
END
= ‘Crop’

Hi @ksitarsk,

as you want to crop the visible process in the process explorer, you need to define a custom dimension in the process explorer. Go to Settings and tick the box for custom dimension then you will be able to define it as usual. Hopefully, this screenshot will help you out.

Use to following function to define your custom dimension:

CASE
WHEN CALC_CROP (FIRST_OCCURRENCE [ ‘STARTACTIVITY’ ] TO CASE_END,
CASE
WHEN “_CEL_O2C_ACTIVITIES”.“ACTIVITY_EN” = ‘Sales Order Released’
THEN ‘STARTACTIVITY’
ELSE NULL END
) = 1
THEN “_CEL_O2C_ACTIVITIES”.“ACTIVITY_EN”
ELSE NULL
END

If you need further support, please feel free to contact us again!

Best,

Justin