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

[Business Rule] Adding IF statement to rule causing significant performance degradation

Accepted answer
82
Views
7
Comments
edited Nov 15, 2023 6:48PM in Planning 7 comments

Summary:

I am trying to add an IF statement to handle cross-year Actual & Forecast situations. However, adding the IF statement causes the rule to increase in run time from 3 minutes to around 40 minutes.

Basically, I need the rule to calculate differently if the current Actual period is Dec of the prior year. All other situations are calculated another way.

See below for the code (note that I use Jan for the IF here because the calculation is FIXed on the forecast month, not actual month. Any recommendations on how to handle this situation efficiently?

Note: Period is dense, and as I understand it, dense dimension members are best used in IF statements as opposed to sparse

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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