Question
Filtering for KPI
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!
+1Hi,
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.