KPI("Number of process variants")
versus
COUNT(
DISTINCT
VARIANT(
"_CEL_P2P_ACTIVITIES"."ACTIVITY_EN"
)
)
image.png900323 21.4 KB
Question
Calculating Number of Process Variants
+11Im having some trouble understanding how the built-in Number of process variants KPI is calculated. I dont understand why these two statements are not equivalent.
+2Hi,
the reason for this is that the Number of process variants saved formula uses the following formula:
COUNT(
DISTINCT
SHORTENED(VARIANT( "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN"))
)
SHORTENED reduces the cycle length to 2. So if you have variants
A->B->B->B->C and A->B->B->B->B->B->C, they are both shortened to A->B->B->C.
This is why your number without the SHORTENED is larger.
Cheers
DavidEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.