Performance
Totals calculated that nothing reads
When no formula reads a line item's totals, its summary still recalculates every parent and time total on each change, so set Summary to None.
What MaxCheck detects
A calculated line item of 1,000,000 cells or more with a summary or time summary on, outside reporting and input modules, whose readers all use it at the same level: each one has at least the same lists and the same time scale, a summary other than Formula or Ratio, and no SELECT, mapping or YEARVALUE-style function that could land on a total. Line items that nothing references are skipped (a page may show their totals), and so is any whose Referenced By names something outside the file.
Why it hurts
Every change recalculates all the parents and time totals of this line item, and they take memory. Here no formula reads them.
Example
Taken from the rule's own test cases: formulas it must flag, and formulas it must not.
WarningFlags this(summed, read only by a same-shape calculation)
- WarningUnitsData.Units * 2
- Time scale: Month
- Summary: SUM
- Time summary: SUM
- 2,000,000 cells
- Referenced by: Revenue
- WarningRevenueUnits * Data.Price
- Time scale: Month
- Summary: SUM
- Time summary: SUM
- 2,000,000 cells
- Referenced by: REP Sales.Revenue
- Revenue'CALC Revenue'.Revenue
- Time scale: Month
- Summary: SUM
Fine (read by a module with fewer lists (it reads the total))
- UnitsData.Units
- Summary: SUM
- 2,000,000 cells
- Referenced by: By Region.Units
- UnitsCalc.Units
How to fix
Set Summary (and Time Summary) to None. If a page or export shows the totals, keep them, or move the totals to a reporting module.
- Severity
- WarningCounts toward the area score.
- Area
- Performance
- Runs in
- Full analysis only
- Rule ID
- P_SUMMARYNOTNEEDED
- Version
- Rule 1.0.0, rule set 1.4.0
- Planual
- 2.03-01 Keep Summary options off by defaulton Anaplan's Line Items page
Does your model do this?
Upload the line-items blueprint. This rule runs in the full analysis, with a work email.