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 @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.

tempsnip396935 25.8 KB

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