Faster method for SUM from multiple sources

aakash · 2025-02-17T10:14:25+00:00

There was an error rendering this rich post.

aakash

Hi Everyone,

Can anyone confirm which of the below is faster?

Final Line Item = Module A. Line Item A [SUM: A, SUM: B, SUM:C] + Module B. Line Item B [SUM: A, SUM: B, SUM:C ]
Line Item 1 = Module A. Line Item A [SUM: A, SUM: B, SUM:C] , Line Item 2 = Module B. Line Item B [SUM: A, SUM: B, SUM:C ] , Final Line Item = Line Item 1 + Line Item 2

Not sure if Anaplan calculates parallelly in the first example.

Regards,

Aakash Sachdeva

Accepted answers

All comments

devrathahuja

Hi @aakash ,
2nd method would be faster since Anaplan can calculate both the line items parallelly as opposed to calculating A & then B in that order.

lokeshm

@aakash two things to consider here, If your using multiple dimensions in the module then you can go with the First option , Since it will help to reduce the total model size. Second thing if you want calculations faster go with the second option. Hope this helps.

PulkitChawla

@aakash - Second approach would be faster but will take more size as you need to create 3 line items.

If you don’t have any size constraints, you can go with this approach but if so then go with approach 1 of having calculated in 1 line item but the computation of this approach will not be faster as compared to second approach.

Dikshant

@aakash In Anaplan, performance optimization depends on how calculations are structured. Between your two approaches:

Single Formula Approach (First Example):Final Line Item = Module A. Line Item A [SUM: A, SUM: B, SUM:C] + Module B. Line Item B [SUM: A, SUM: B, SUM:C ]
- This combines both SUM operations in one formula.
- If Anaplan can execute the SUM functions in parallel, this could be slightly more efficient.
- However, it forces Anaplan to recalculate the SUM for both modules each time the Final Line Item is referenced.
Intermediate Line Item Approach (Second Example):

Line Item 1 = Module A. Line Item A [SUM: A, SUM: B, SUM:C] , Line Item 2 = Module B. Line Item B [SUM: A, SUM: B, SUM:C ] , Final Line Item = Line Item 1 + Line Item 2

This approach stores SUM results separately.
If multiple calculations rely on the SUMs, Anaplan can reuse the results without recalculating.
More readable and potentially avoids redundant calculations.

Which is faster?

If SUM is expensive and used multiple times, the second approach is likely faster because it avoids repeated recalculations.
If the SUM functions are only used once, the first approach might be marginally faster but could impact model performance due to recalculations.

Go with the second approach if your SUM functions are large, used multiple times, or referenced elsewhere.

SriNitya

Option 1 → if size is not the issue
Option 2 → fast solution
By option 2 you can calculate once and refer multiple times would work.

Quick Links

Can you help?

Unanswered questions

Dimensionality - Formula Help
I have a Price module where customers are ranked based on their unit prices. I also have a Comparison module, where I want to display the names and unit prices of top-ranked customers for comparison. The model includes a Customers list. In the Comparison module, I want to write formulas to bring in the customer names and…
Can there be a duplication in Process ID's
Can there be a duplication in Process ID's
Using Polaris and Classic
Client has spoke models built in Classic and now considering building Data Hub in Polaris in order to deal with sparsity. On the surface this seem possible but likely a bad idea. Has anyone done anything similar to this? Specifically, what did you have to do to ensure that data was compatible? Any thoughts or suggestions…