Variance Calculations in CalcMgr Rule?
SummaryExperimenting with variance calculations in calcmgr rules, need some advice/help
We've been experimenting with making some of our sparse dimensions dynamic calc at the upper levels, which has significantly sped up a lot of our business rules, due to being less reliant on running aggregations. However, it has slowed down the retrieval time for our variance calculations (dynamic calc scenario member).
I've been experimenting with setting the variance scenario member to be store and performing the variance calculation in calculation manager rules. When referencing the same Version member, the calculation is fast and works fine. However, when I use a formula, and cross between Version members (eg.