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?
Page 1 / 1
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
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!
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,
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.