Sustainable
Many dimensions
Each dimension multiplies the cell count, so a line item with more than five usually holds mostly empty combinations.
What MaxCheck detects
A line item with more than 5 dimensions (lists, plus time and versions when they apply).
Why it hurts
Each dimension multiplies the cell count. Most combinations are usually empty.
Example
Taken from the rule's own test cases: formulas it must flag, and formulas it must not.
HintFlags this(4 lists + time + versions)
- Applies To: A, B, C, D
- Time scale: Month
- Versions: All
Fine (5 lists)
- Applies To: A, B, C, D, E
How to fix
Drop dimensions the value doesn't vary by, or split the calculation into smaller modules.
- Severity
- HintShown in the report. Hints never count toward a score.
- Area
- Sustainable
- Runs in
- Basic and full check
- Rule ID
- S_MANYDIMENSIONS
- Version
- Rule 2.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.