Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Variance Calculations in CalcMgr Rule? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Variance Calculations in CalcMgr Rule?

Received Response
26
Views
1
Comments
edited Mar 31, 2021 11:23AM in Planning 1 comment

Summary

Experimenting with variance calculations in calcmgr rules, need some advice/help

Content

Hi,

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!