Performance
Very large line item
A line item of 50 million cells or more drives model size, memory and calculation time, and most of its cells are often empty.
What MaxCheck detects
A line item with 50M cells or more. One finding per line item, at the highest tier reached (50M, 100M, 500M, 1B).
Why it hurts
Big line items drive model size, memory and calculation time. Most of their cells are often empty.
Example
Taken from the rule's own test cases: formulas it must flag, and formulas it must not.
WarningFlags this(exactly 50M)
- 50,000,000 cells
Fine (just under 50M)
- 49,999,999 cells
How to fix
Remove dimensions the value doesn't vary by, use a narrower time range, or move the calculation to a smaller module.
- Severity
- WarningCounts toward the area score.
- Area
- Performance
- Runs in
- Basic and full check
- Rule ID
- P_TOOBIGLIS
- Version
- Rule 1.0.0, rule set 1.4.0
Does your model do this?
Upload the line-items blueprint. This rule runs in the basic check, in your browser, with no email.