Hello,
Is it possible to filter an OLAP table column for specific KPI values? Specifically, if we have an OLAP with some table attribute as the dimension and a KPI which calculates numerical values, is it possible to filter the KPI column for KPI(" ") > 0?
Thanks!
Page 1 / 1
Hi,
this is not possible when you use regular aggregations. However, you can use PU aggregations to calculate the KPI. In this case, filtering is possible.
Please take a look at the description and examples of PU functions in the PQL function reference, which you can find in your documentation.
Cheers
David
this is not possible when you use regular aggregations. However, you can use PU aggregations to calculate the KPI. In this case, filtering is possible.
Please take a look at the description and examples of PU functions in the PQL function reference, which you can find in your documentation.
Cheers
David
Hi David,
Thanks for the feedback, this helps!
Best,
Hormoz
Thanks for the feedback, this helps!
Best,
Hormoz
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.