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
Page 1 / 1
(post withdrawn by author, will be automatically deleted in 24 hours unless flagged)
Hello Paul,
you can use a PU aggregation for this. Checkout the second example of help.celonis.cloud/help/display/CIBC/PU_COUNT
Cheers
David
you can use a PU aggregation for this. Checkout the second example of help.celonis.cloud/help/display/CIBC/PU_COUNT
Cheers
David
This 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.
Hi 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
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?
The 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
Best
David
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.