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!

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

Hi David,

Thanks for the feedback, this helps!

Best,
Hormoz