[Analysis] How can I get the CASE FLOWS THROUGH behaviour Any/All from the Activity Selection when selecting data from an OLAP table?

Hi there,

The Activity Selection filter has an option where we can filter cases that flow through all or any multiple activities.I want to select a bunch of activities and filter cases that flow through any of them.

Since this filter is used frequently I created an OLAP table with one category per row.

OLAP Table Inverted selection

I assumed that, selecting a row and inverting the selection would give the same result as activities flow not through ANY cases in the Activity Selection. However the results are not the same. In fact, inverting the selection does not change the total amount of cases.

So this raises some questions.

What does the invert selection option do and where can I read about it?
Can we get the same functionality as in the Activity Selection filter (multiple activities flowing through any ) in an OLAP table?
I used a CASE WHEN statement to create the categories in the OLAP table. Is there another way of doing this?

CASE

WHEN "_CEL_O2C_ACTIVITIES"."ACTIVITY_DE" LIKE 'Ändere

Bonitätssperre%'

THEN 'Ändere Bonitätssperre'

WHEN "_CEL_O2C_ACTIVITIES"."ACTIVITY_DE" LIKE 'Setze

Bonitätssperre%'

THEN 'Setze Bönitatsperren'

-- and some more WHENs

ELSE NULL

END

Al the best,

Saša

Page 1 / 1

Dear Sasa,

Kindly note that we are currently reviewing the questions raised and have already engaged additional Celonis resources on this.
Your patience and understanding are highly appreciated.

Thanks Burim, I am curiously awaiting the answer. My guess is that the filter in the OLAP table is the same as using ANY in the Attribute Selection. I just get a different behaviour which makes me questioning.

Dear Sasa,

please find the answers, as per below:

1. The invert selection option inverts the values selected in the table, so Not Setze Bönitatsperren is equivalent to selecting all activities in _CEL_O2C_ACTIVITIES except Setze Bönitatsperren. The total cases don't change because all cases have at least one activity that isn't Setze Bönitatsperren.

2. You can't get the same functionality in an OLAP. However, you can use:

a button dropdown to write selected activities to a variable, and apply the sheet filter FILTER "_CEL_O2C_ACTIVITIES"."ACTIVITY_DE" IN (<%=activities%>). Make sure to set commas as separators and

single quotes as wrapping characters.

the Activity Explorer component.

3. You could try the following:

Combine PATINDEX and SUBSTRING to extract the part of the string before some character
Create a new column in _CEL_O2C_ACTIVITIES and reference this new column instead of the CASE WHEN statement

Many thanks and best regards,

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