Anaplan (as with computers in general) is optimized for numbers and Booleans. Text formats use more memory than any other format due to the way computers need to store the data. Minimize the use of te…
RANK is a calculation intensive formula that cannot multi thread. Used in conjunction with large lists it can lead to poorly performing calculations. The same applies to RANKCUMULATE Exceptions to thi…
The engine works more efficiently when calculations are broken up into separate line items. So, break up formula expressions where possible. This is especially true for calculations that are reference…
Avoid using multiple IFs. It is better to split the formula into more line items, use LOOKUPs or alternative constructs Best Practices article: Line Item Subsets Demystified Decreasing the Length of Y…
Create Calculation modules to house sets of line items that use the same dimensionality. Avoid using Subsidiary views Related to Rule: 2.01-06 Avoid using Subsidiary Views Best Practices article: Line…
Turn off summary options by default. It is better to use SUM for any downstream aggregation if not all levels are needed Exception: 2.01-10a All aggregation levels are needed: If all aggregation level…
Create a System module to support all standing data and attributes about the hierarchy (all levels). At a minimum have the code and parent as line items Exception: * 2.01-08a: If the hierarchy is not …
Create all functions and filters relating only to time in separate modules. They will only re-calculate on model opening and when the time settings change It is best practice to use a separate module …
Within functional areas, group "like" modules together. Design for the type of module and use the appropriate structures Best Practices articles: Best Practices for Module Design Reduce Calculations f…
Using switchover means the historic periods are effectively cleared out. This does have the benefit of reducing model size as the historic cells are cleared, but switchover should be moved forward onl…
* Introduction to Sparsity (309) * Eliminating Sparsity (310) This set of training classes includes information on improving model performance by understanding and eliminating sparsity. Classes includ…
