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
