Formulas: 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?

Combining text strings takes a lot of memory and can impact performance.


How to correct:

Create systems modules that only include the dimension needed. For example, if you want to create a code that consists of an item code and a company code joined together, you would create three systems modules. One that holds the item data, another that holds the company data, and a third that holds the combination of the two.


More information:

Formula Optimization

String Concatenation


Model Optimization Checklist