How to identify starting and ending activities of a process. They are reflected by a link from 'Process Start' to starting activities and a link from ending activities to 'Process End' in Variant explorer.

I've extracted all the variants that contains list of activities. In my case their are 648 variants. I need to identify which are the starting and ending activities of process. Can i assume that first activity in each variant is starting activity and last activity in variant is the last process activity that lead to 'Process End'?

648 Varints I've also comp up with query to create statistics between each link of activities as shown below. But i'm not sure how would i identify and calculate stats for 'Process Start' and 'Process End'.

Page 1 / 1

use Pull up functions to identify the first and last activity information for the particular case.

PU_FIRST(CASETABLE,ACTIVTYTABLE.ACTIVITYCOLUMN)

PU_LAST(CASETABLE,ACTIVTYTABLE.ACTIVITYCOLUMN)

Your assumptions are correct. A good way to confirm it is checking a few cases in Process Overview

celonis.cloud/help/display/CIBC/Process+Overview

Similar result can be achieved with PU_FIRST a nd PU_LAST functions

celonis.cloud/help/display/CIBC/Cheat+Sheets?preview=%2F34472017%2F55706342%2Fcheat_sheet_pu_functions.pdf

Hi Obaid,

Yes your assumptions are right, that is how first and last activity works for the variant.

You can leverage Process overview functionality of celonis to identify few cases, infact you will get a good idea from there.

Also you can use following PQL query to check the start and end case count

FILTER DOMAIN MATCH_ACTIVITIES(STARTINGT'Activity Name'] ENDINGD'Activity'] ) = 1

Hope it helps.

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN