User bio
404 bio not found
Member since Oct 23, 2023

I got an answer to this question internally and am reposting it here. From Daniel Bissex:

Using the MDX COUNT function is the slower of two options. We also have a provided Distinct plugin to address exactly this inefficiency:

This uses our %KPI() function syntax, more detailed description of the calling options can be found here:

This reduced the runtime from ~5 minutes to about two seconds! The linked documentation is for IRIS 2023.1, but these functions are available in 2022.1 as well.

Certifications & Credly badges:
Nick has no Certifications & Credly badges yet.
Global Masters badges:
Nick has no Global Masters badges yet.
Nick has no followers yet.
Nick has not followed anybody yet.