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.
Many thanks!