Sustainable
Many dimensions with a list summary
A list summary on a line item with more than four dimensions stores totals for every parent of every list, multiplying the cells again.
What MaxCheck detects
A line item with more than 4 dimensions and a summary other than None.
Why it hurts
Summaries are stored for every parent of every list, which multiplies the cells again.
Example
Taken from the rule's own test cases: formulas it must flag, and formulas it must not.
WarningFlags this(5 dims with sum)
- Applies To: A, B, C, D, E
- Summary: SUM
Fine (4 dims)
- Applies To: A, B, C, D
- Summary: SUM
How to fix
Set the summary to None where the totals aren't read, or total in a smaller reporting module.
- Severity
- WarningCounts toward the area score.
- Area
- Sustainable
- Runs in
- Basic and full check
- Rule ID
- S_MANYDIMENSIONS_SUM
- 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.