Filter variant explorer by activity

Hello,

I am trying to filter a variant explorer by activity and not by case.
I want to hide certain activities from the filter, but without doing it manually from the hidden activities dropdown, so that I can assign a variable to it and change it dynamically.
Is there any way to do this?

Many thanks

Hi @Ale,

you could define a custom dimension. The custom dimension can be defined as follows:

CASE
WHEN “Activity Table”.“Activity Column” IN (<%= Variable %>)
THEN NULL
ELSE “Activity Table”.“Activity Column”
END

The custom dimension can be defined in the component settings of the variant explorer.
In case you need support on how to define the variable, feel free to reach out to us again.

Hopefully, that’ll solve ysour issue!

Best regards,

Justin

Hi @j.stegmaier,
how could I get the same result on CPM4 ?

Hi @Dennis.A,

on which CPM4 version are you working? In case it is 4.5 you can define a custom dimension.

Best,

Justin

Hi @j.stegmaier,
at the moment we are on Celonis 4.5 (4.5.0-RELEASE_db6cb69_20190315_1907) and I don’t see the option for custom dimension:
CPM4_5

compared to IBC:

Hi @Dennis.A,

unfortunately then it is not possible. You need to upgrade your CPM 4 to use custom dimensions.

Best,

Justin