Skip to main content
Question

Filtering for KPI

  • April 16, 2020
  • 2 replies
  • 15 views
H
Level 2
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!

2 replies

D
Level 1
Forum|alt.badge.img+2
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
H
Level 2
  • hormoz.izadi
  • Author
  • Level 2
  • April 23, 2020
Hi David, Thanks for the feedback, this helps! Best, Hormoz
Community Code of ConductAccessibility statement