Skip to main content

Variant and Process Explorer not filtered when using CALC_CROP in load script

 

 

How to ensure that Variant and Process Explorer are filtered when using CALC_CROP or CALC_CROP_TO_NULL in Load Script (Analysis/Tab/Component). When the crop is done through Selection Views, it works correctly, but when the crop is done using PQL in Load Script, filter does not work for Variant and Process Explorer. Examples below:

 

FILTER ISNULL(CALC_CROP_TO_NULL(FIRST_OCCURRENCEN'XXXXX'] TO CASE_END, ACTIVITY_COLUMN())) = 0

 

Or FILTER CALC_CROP ( FIRST_OCCURRENCEE'XXXXX'] TO CASE_END, ACTIVITY_COLUMN()) = 1

 

 

Thanks

 

If CALC_CROP_TO_NULL(FIRST_OCCURRENCE['XXXXX'] TO CASE_END, ACTIVITY_COLUMN()) is used in the Custom Dimension of Process and Variant Explorer, instead of Load Script filter, then it will be possible to filter the activities in PE and VE


Reply