Skip to main content
Question

Component Filter: Crop Process

  • January 28, 2020
  • 6 replies
  • 10 views
C
Level 4

Hi,

Id 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

6 replies

J
Level 0
  • justin.stegm
  • Level 0
  • January 29, 2020

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

C
Level 4
Hi Justin, thank you, it worked! Best regards, Carina
C
Level 4
Hi Justin, I have an other question. What is the right code to use this as a component filter? I know, the filter starts like this: FILTER PU_FIRST ( VBAP, _CEL_O2C_ACTIVITIES.ACTIVITY_EN) = AV: Create Invoice AND ? I dont know how I get the process end. Thank you! Best regards, Carina
J
Level 0
  • justin.stegm
  • Level 0
  • February 25, 2020

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

K
Level 5

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

J
Level 0

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

Community Code of ConductAccessibility statement