Performance
CUMULATE used
CUMULATE is normal Anaplan, but on a long timeline or a big list a PREVIOUS-based running total can be cheaper.
What MaxCheck detects
CUMULATE on any time scale other than Day, or over a list.
Why it hurts
CUMULATE is normal Anaplan, but on long timelines or big lists a PREVIOUS-based running total can be cheaper.
Example
Taken from the rule's own test cases: formulas it must flag, and formulas it must not.
HintFlags this(month cumulate)
CUMULATE(Sales)
- Time scale: Month
Fine (no cumulate)
PREVIOUS(Balance) + Sales
- Time scale: Month
How to fix
Usually nothing. If the line item is slow, compare with Value = PREVIOUS(Value) + Amount.
- Severity
- HintShown in the report. Hints never count toward a score.
- Area
- Performance
- Runs in
- Basic and full check
- Rule ID
- P_CUMULATE
- Version
- Rule 1.0.0, rule set 1.4.0
- Planual
- 2.02-10 Use PREVIOUS rather than CUMULATEon Anaplan's Formulas page
Does your model do this?
Upload the line-items blueprint. This rule runs in the basic check, in your browser, with no email.