Skip to main content

Hello everyone,

 

I have a problem with events that I have excluded via analysis settings. 

In the script I have mapped activities with NULL as follows: 

 

FILTER 

"CEL_LBU_ACTIVITIES". "ACTIVITY_DE"=REMAP_VALUES("CEL_LBU_ACTIVITIES". "ACTIVITY_DE",u'Order Confirmation', NULL],U'Order Receipt', NULL],U'Message Accepted', NULL], L'Change of Processing Location', NULL]);

 

It has been noticed that this line is not sufficient to completely remove the activities. The Process Explorer, Case Explorer as well as SOURCE()/TARGET() functions still contain these activities. 

I did not want to change the data in the database and hope that there is a simpler solution to the problem.

 

Maybe someone can tell me how to remove the activities from this analysis.

 

Many thanks 

Laura

Good morning! In our 'Manual Touch' analysis, one of the tabs has several activities removed. Below is the formula we are using. It successfully removed the activities from the tab within the analysis.

 

FILTER (_CEL_O2C_ACTIVITIES.ACTIVITY_EN) NOT IN ('Send Order Confirmation', 'Receive PO', 'Material Availability Date passed', 'Due Date passed: Invoice', 'Due Date passed: Credit memo', 'Due Date passed: Debit memo',

'Due Date passed: Intercompany invoice', 'Due Date passed: Intercompany credit memo', 'Create Delivery', 'Clear Invoice', 'Create Invoice', 'Create Intercompany invoice', 'Clear Intercompany invoice');


thank you Kayla for providing this workaround.
Laura, can you please try this out and let us know if this works for you?

good morning,

Thanks for the tip. I have tried this code but the Process Explorer, for example, still contains the activities to be excluded. Unfortunately, the problem persists.


Good afternoon,

 

In order to remove these activities from your analysis you can do it with the following:

 

If you open the Analysis settings (three bars on the top left) and select the load script, the following code will filter the entire analysis for the activities that you marked:

 

FILTER CALC_REWORK( UPPER("_CEL_P2P_ACTIVITIES_EN"."ACTIVITY_EN") IN_LIKE (

'ORDER CONFIRMATION', 'ORDER RECEIPT', 'MESSAGE ACCEPTED', 'CHANGE OF PROCESSING LOCATION'

) ) = 0

 

Let us know if it worked :)


good morning,

 

Unfortunately, it still does not work. We have now decided to remove the activities from our database in the background. This will definitely solve our problem. Thanks to all for the suggestions


Hi @schauer.schau 

 

To hide certain activities which you don't want in the analysis you can simply leverage the hide activity feature of Celonis which is there in Variant and Process Explorer.

 

 

The below snap shows the same and once you click on that eye button you can find the list of activities and you can deselect the activity of your choice which you want to hide.

 

image 

To completely remove them from analysis, I think you have to go back to transformation and tweak the logic there.

 

 

Hope it helps.


Hi @schauer.schau,

 

Rohit's advice will probably help you already. In case you decide to tweak something in the event collection, I would recommend disabling the datajobs that create these activities rather than deleting them completely. Therefore you can easily comment them in again in case you need them and do not have to build them from scratch. This safes you time 🙂.

 

image 

Best

Kevin


Hi @Rohit Kumar , @kevin.flesc ,

Thank you very much for the suggestions. We will gladly turn them in.


@schauer.schau 

Hiding the activities from the Process Explorer/Variant Explorer, would not solve your problem as it would still exist in the DM (still affecting KPIs such as manual touchpoints). The best solution is to deactivate them in the Event Collection.

 

Best,

Gabriel


Reply