Performance Comparison - OFFSET/LAG/PREVIOUS/LOOKUP
Was looking to get some input on a calculation scenario as community pages were a bit vague (or I'm using the wrong keywords).
Now, I'm sure most of us understand how Anaplan thrives on being multi-threaded where possible, but when it comes to performing time-based calculations, there's a variety of ways to do the same thing.
For example, when attempting to retrieve a value from a previous period, you can use,
OFFSET(Source Line, -1)
LAG(Source Line, 1, 0)
Source Line[LOOKUP:Previous Month Lookup]
I'm conscious that in some cases, particularly when the line item is a circular reference (i.e. referencing a previous period of itself), the LOOKUP option isn't possible.
My understanding is that with exception of the LOOKUP method, all other calculations were serial-type calculations which would infer significantly slower performance when used repeatedly (versus LOOKUP), but I was curious whether there's any actual bench-marking into how efficient (or rather, inefficient) each version is.
Reason for my question is that our team is currently undertaking a review of our models/model performance and are attempting to optimise where possible.