Question
Aggregation filter for a table with a dimension
Hello,
I have a question on how to filter a table with a dimension, and a aggregation.
For example I have a olap table with:
Dimension A | Count(Dimension)
abc | 5
cde | 10
Now I would like to create a filter on top of this olap table and filter out everything that has a count of the dimension lower than 6.
From the documentation regarding filtering I understand that I filter will not work, in this post I am looking for an alternative.
https://zalando.eu-1.celonis.cloud/help/display/CIBC/FILTER
I would appreciate any help on how to do this.
Best,
Paul
+2Hello Paul,
you can use a PU aggregation for this. Checkout the second example of help.celonis.cloud/help/display/CIBC/PU_COUNT 
Cheers
David
Cheers
DavidThis works, however if I put a filter in the load script, then it will not give me the correct result anymore, since the PU somehow ignores this filter.
+2Hi Paul,
yes, PU functions do not respect filters and selections. However, you can pass a filter statement inside the PU function. You can see examples in the Documentation mentioned above.
Best
David
I see. Is this not a bit weird behaviour, since I as a user would expect that sheet or analysis filters are respected for all calculations in the sheet or analysis?
+2The reason for this behavior is that PU functions were designed to be used in a FILTER statement (like you do here as well). If they would consider FILTERs themselves, the order of the FILTER statements would matter. However, FILTER statements in Celonis are stable, which means they dont interfere with each other.
Best
David
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.