Performance
CUMULATE on a day time scale
CUMULATE on a Day time scale sums every earlier day for every cell, so its cost grows with the square of the timeline; use PREVIOUS instead.
What MaxCheck detects
CUMULATE in a line item whose time scale is Day.
Why it hurts
A day-level CUMULATE sums over every earlier day for every cell. Cost grows with the square of the timeline.
Example
Taken from the rule's own test cases: formulas it must flag, and formulas it must not.
ErrorFlags this(day cumulate)
CUMULATE(Sales)
- Time scale: Day
Fine (month cumulate)
CUMULATE(Sales)
- Time scale: Month
How to fix
Use PREVIOUS: Value = PREVIOUS(Value) + Daily Amount. Or cumulate at month level and spread to days.
- Severity
- ErrorCounts toward the area score.
- Area
- Performance
- Runs in
- Basic and full check
- Rule ID
- P_CUMULATEDAYS
- 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.