Performance
TIMESUM in a line item with time
TIMESUM in a line item with time redoes the whole sum for every period, so its cost grows with the square of the timeline.
What MaxCheck detects
The TIMESUM function in a line item that has a time scale and 100,000 cells or more.
Why it hurts
TIMESUM adds up a range of periods. In a line item with time, Anaplan redoes the whole sum for every period, so the 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.
WarningFlags this(monthly line item)
TIMESUM(Sales)
- Time scale: Month
- 120,000 cells
Fine (no time)
TIMESUM(Sales)
- 500,000 cells
How to fix
Use YEARTODATE, MOVINGSUM or CUMULATE for running and rolling totals, or SELECT: TIME.All Periods for a total. Keep TIMESUM for line items without time.
- Severity
- WarningCounts toward the area score.
- Area
- Performance
- Runs in
- Basic and full check
- Rule ID
- P_TIMESUMONTIME
- Version
- Rule 1.0.0, rule set 1.4.0
- Planual
- 2.02-21 Avoid Using TIMESUM with Timeon 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.