-
Is the main time scale of the model larger than it needs to be?
When is this a problem? Each year that is included in the model calendar increases the size of the model. When used for planning purposes, it's likely that only certain data sets are needed, leaving many empty cells. Why is this a problem? It is unnecessary to increase the model calendar years when Time Ranges are…
-
Are all the actions necessary?
When is this a problem? When there are unused actions that haven't been deleted. Why is this a problem? It is very hard to audit which actions are being used. How to correct: Remove any unused actions. More information: Planual 5.01-04 Best Practices for Model Cleanup Questions on this topic? See Are all the actions…
-
Are there line items that can be placed in a systems module rather than within a calculation module?
When is this a problem? Look for functions that result in data that doesn't change (i.e., the parent of a line item). Placing these functions in a systems module means that the calculation is run once and can be referenced by multiple line items in multiple modules. Look for: PARENT(PARENT(PARENT(line item))), text field…
-
Which line items do not need a summary?
When is this a problem? When a new line item is created, a summary method is added by default. Many line items do not need summary calculations. Why is this a problem? Running unnecessary calculations can increase the time it takes to open a model. How to correct: When creating a new line item, make it a habit to turn off…
-
Does the list use Time as part of the key?
When is this a problem? This is most often seen in a transactional list when creating a unique value for an item to import to a list. Why is this a problem? Thinking about this from a list creation point of view, do you really want to create a new list item for every date, or do you want to create the list item once? If…
-
What dimensions are used in the module? Are they all necessary?
When is this a problem? This is a problem when you have unnecessary dimensions—meaning that the logic or data in the module does not apply to the dimension. Why is this a problem? Unnecessary dimensions in a module could cause poor performance from a formula having to perform unnecessary calculations and increasing the…
-
Are text formatted line items overused?
When is this a problem? Anaplan is optimized for numbers and Booleans. Why is this a problem? Text uses more memory than most other model components and does not perform as well as other data types. Text limits capabilities and impacts model size. How to correct: When possible, convert text data to another data type. Check…
-
Do any of the actions result in errors when they are run?
When is this a problem? When you receive a yellow exclamation point, that is an error. You may also see warnings. Both errors and warnings need to be corrected. The action or process should show all green checkmarks. Why is this a problem? Imports will run, but the errors and warnings will result in missing data. How to…
-
Are there any formulas that that combine text strings?
When is this a problem? The use of text strings in Anaplan cannot be avoided, so you must ensure that the joins are done in the most efficient way to minimize the impact on performance. Be sure to read the Formula Optimization article. You can find the link in the More Information section below. Why is this a problem?…
-
What time dimensions are being used in the module? Can a Time Range be used?
When is this a problem? This is a problem in models where the time requirements of the module differ from the Model Calendar. This could mean that the year requirements are outside of the model calendar or do not need all of the years in the model calendar. It is also a problem to include unnecessary time summary settings.…