Thanks Paul! That lends me confidence to consolidating these aggregation/lookup properties into a single location. I'm in the same boat, working with a large model hitting over 80GB - my main motivation for this question was to consolidate these SUM/LOOKUP properties into a single location, mainly for maintenance purposes, however did not want to suffer any performance impacts as a result of this. We had quite a rapid development phase, with a number of Anaplanners working on the model - as such, it was difficult to coordinate what helper properties for aggregations/lookups existed, and where they were. What we eventually ended up with was (essentially) the same aggregation property in multiple locations, e.g. Schedule 1.Total Revenue = Schedule A.Revenue by Product[SUM: Schedule A.Store] Schedule 1.Total Profit = Schedule B.Profit by Product[SUM: Schedule B.Store] etc, where Schedule A and B had the exact same dimensionality It's a simplified example above, but the two line items in the SUM statement should (in my opinion) be consolidated into one, in a central location (such as the register for Product). Thanks again for the answer!
... View more
Is anyone able to describe the performance impact (if any) of referencing line items from other modules or lists which have the same relevant dimensionality? Particularly using SUM and LOOKUP operators.
For example, a model may have a Register A and a Schedule B (over time), both of which have the same dimensionality (Product). A third Schedule C has a different dimensionality, say Store, which has an implicit relationship with Product.
Something like total revenue (by Product) may be calculated in Schedule B, and needs to be aggregated up into Schedule C (by Store). Is there any performance impact if the aggregation helper is in a different location to the source line item?
A couple of different ways this could be done is:
Schedule C.Total Revenue = Schedule B.Revenue by Product[SUM: Register A.Store]
Schedule C.Total Revenue = Schedule B.Revenue by Product[SUM: Product.Store]
Schedule C.Total Revenue = Schedule B.Revenue by Product[SUM: Schedule B.Store]
(Where Register A.Store and Schedule B.Store are non-time dependent items returning the Store for the specific Product, and Product.Store is a list property returning the Store for the specific Product.
... View more