Skip to main content

Hy,

In analyses when we add a KPI in an OLAP, the OLAP automatically filters but in view tables I am seeing 0's with 1's, I want to exclude all the 0's and that too based on a view variable

 

Any help ?

The way you filter views using view variable is as follow

 

id: ${ (VARIABLE === 'EXPEXTED_VARIABLE_VALUE' && 'KM_FILTER_ID')}

 

Which is more like

 

IF VARIABLE === 'EXPEXTED_VARIABLE_VALUE' THEN 'KM_FILTER_ID' where ,KM_FILTER_ID' is the KPI ID

 

Please refer to the following link and look at Filtering with variables (input) that are strings section

https://docs.celonis.com/en/views-filters.html#UUID-ce16c4c4-f584-c2fc-4f59-52f0302f4be5_id_ViewsFilters-Filteringwithvariablesinputthatarestrings


Hi @Abhishek Chaturvedi !

 

Do you have some example to use view variable in filters?

 

Where this Id is define? In YAML KM or YAML Olap?

 

Thanks


image


image

Thanks @Abhishek Chaturvedi 


Reply