As model builder I would like to make use of sequential lists (Array or Linked list) to avoid circular references. This can be useful in many calculations..
Native functions like PREVIOUS() or NEXT() could only be applied on line items which are on the time dimension. Such functions should then also work for the sequential list as well, without causing a circular reference. Theoretically you don't have a circular reference if the list is properly sequenced with a PREVIOUS and NEXT item.
At the moment if I require this I map the original list item to a date. Do the calculations on that 'date' item and then map it back to the original list item. E.g. for an allocation algorithm allocating demand based on margin using constrained capacity buckets. The workaround is however limited as you can only use 1 time dimension per module/line item.
The content in this article has not been evaluated for all Anaplan implementations and may not be recommended for your specific situation.
Please consult your internal administrators prior to applying any of the ideas or steps in this article.