Skip to main content

Hi!! I'm interested in filtering an activity out of an analysis. When I try to filter out the activity from the attribute selection, the activity still shows in the Process Explorer. Is there a way to do a crop selection type filter in the load script?

Hi @remington.roger11,

 

What you can do to remove it from the process or variant explorer, is to use the 'Custom Dimension' field, and enter the REMAP_VALUES function:

 

REMAP_VALUES ( "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" , ; 'CREATE PURCHASE ORDER' , NULL ])

 

Unfortunately, this function cannot be used in the Load Script section (as far as I know), but in combination with the method you mentioned in your question, the activity is no longer visible in the analysis.

 

Cheers,

Jan-peter


Indeed. I have found that the load script filters cases, but the process explorer will always show all activities (and connections) from these cases.

If you want to filter out activities you need to specify a custom dimension to return NULL for the activities you want out.


Hi @remington.roger11,

 

What you can do to remove it from the process or variant explorer, is to use the 'Custom Dimension' field, and enter the REMAP_VALUES function:

 

REMAP_VALUES ( "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" , ; 'CREATE PURCHASE ORDER' , NULL ])

 

Unfortunately, this function cannot be used in the Load Script section (as far as I know), but in combination with the method you mentioned in your question, the activity is no longer visible in the analysis.

 

Cheers,

Jan-peter

Great suggestion, I will give this a try!!! Thank you


Reply