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?
Question
Maximum cardinality exceeded when using calculations
+6- Master Author
+8- Employee
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,
+6- Master Author
Hi
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!
+8- Employee
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,
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.