Maximum cardinality exceeded when using calculations

Hi,

I was trying to use Calculations and faces maximum cardinality issue.
I have metrics for BoP, EoP and 2 metrics I need to add.
So, the logic would be EoP = BoP + Metric 1 + Metric 2

Each of them has 6 dimension, and unfortunately I can’t get rid of any dimensions.

We used the logic of where BoP = EoP {select month -1] and EoP is calculated as previous month + Metric 1 + Metric 2 but we faced formula timeout recently.

Maybe anyone has any ideas how it can be solved?

Be the first to reply!

Hi Alina,

Are there 0s in the metric that could be replaced with Blanks? If so, you could try adding

[FILTER: currentvalue <>0]

in each of the source metrics and see if that helps.

If that doesn’t help, please share some screenshots of the metrics in question.

Cheers,

Hi @Matt D

A bit updated my logic, now I don’t have issue with max cardinality but I have formula timeout.

I split the metrics into 2 parts: Act and Plan data, and even for act I have formula timeout.
Please, see the screenshots attached. I can’t get rid of any other dims (incl currency because of the logic of how we calc Consolidated entity - it’s not simply a sum of entities but rather some PnL items have exception)

Thanks!

@Alina and I jumped on a call to discuss this.

The issue was coming from the fact that PREVIOUSBASE() was being used incorrectly. We amended the formula and used PREVIOUS(Month) instead, which resolved the problem :)

Thanks,

Ask your question here!

Not finding what you're looking for?

Sign up

Single Sign-On Need help?

Log into the Pigment Community

Single Sign-On Need help?

Scanning file for viruses.

This file cannot be downloaded