Hi Community! How can I use the View Variable into a Filter expression?

Hi You can try with ${Var_Name}

Hi Kailash! Thanks for your response!

I'm try to use. But Celonis don't reconigze the View Variable:



Hi Claudio,

can you put the '${id}' between single quotes like this?

'${variable}'

Hi @gabriel.okaba11 

I try, but returns the same error:

Thanks

hi @Claudio Tatiyama 

you are setting up a view variable (see details here https://docs.celonis.com/en/views-variables.html#UUID-8808e9b5-f434-b598-3298-7dd183ddc913_id_ViewsVariables-Introductiontoviewvariables)

but trying to use them as filters in the KM, correct?

can you create the same id variable in the KM instead of the view and try again?

@gabriel.okaba11 , that's right!

Yeah, I'm trying to use a View Variable into KM Filter. I create the variable "id" into KM, but the right content is on View Variable "id" and not into KM Variable "id", then the filter doesn't work because the KM Variable is empty. I should use the View Variable into KM Filter anyway.

Hi Claudio,

If you want to use View Variables in KM, i will suggest to use Runtime Variable but if your requirement is specifically to use view variable you can try "KPI Params" (https://docs.celonis.com/en/knowledge-model---kpis.html).

Attached screenshot might help you.

Using Variables in Views directly:

Using Runtime variable in KM (${{Variable_Name}}:

Just in case, we have defined variables in KM. We can use them in other KPI's in the KM (as ${variable})

We can not use them from an Analysis that is linked to that KM (and it is a pity)

I was having the same issue - wanted to reference KM variable accross our many Studio analyses e.g. for unification of filters.

I recently talked to our Celonis contact and got following workaround recommendation:

Define a variable in the KM, reference a KPI to this variable, and use the KPI in your analysis because KPI from KM are accessible from Studio Analysis.

This solution is so far sufficient for my purposes. However, I believe it can have limitations.

Hope it can help some of you as well!

Yep I just tried that. Worked in certain cases but, for example, I want to keep the list of activities that define a part of the process ... like ('A','B','C') so I can use it in a PROCESS EQUALS or in a WHEN Activities IN (...)

Well, when you try to add that to a KPI, PQL insists in treating it as a instruction and not as a string, and throws errors.....

Ok, I believe there are cases for which it doesn't work but I take it so that the KM was meant to work together with Views in the first place. So it's nice to have any features that can be leveraged also within the old good analyses :-)

Hello guys!

I appreciate all comment about the question.

I'm tryng to detail my problem below:

Thanks

Hi Claudio,

Instead of defining the filter in KM, add the filter statement directly on OLAP table yaml editor in Profile view. It is worked in my case.

Hi @kailash.potha12 

Thank you so much for your help. It worked! I was too many days stopped with this problem!

Thank you!

You are welcome 😊