How to improve Anaplan performance

CommunityMember125605

Hello.

I'm searching how to improve Anaplan performance.

If you have good textbook or Best Practice, please tell me.

Like this site

https://community.anaplan.com/t5/Best-Practices/Formulas-and-their-effect-on-model-performance/ta-p/33556

Accepted answers

prabhu

Hi @CommunityMember125605,

You can read these link.

https://community.anaplan.com/t5/Best-Practices/Reduce-Calculations-for-Better-Performance/ta-p/33667

https://community.anaplan.com/t5/Best-Practices/Good-Practices-to-Improve-Model-Performance/ta-p/33550

https://help.anaplan.com/anapedia/Content/Calculation_Functions/CF_Optimizing_Time_Calculation_Performance.html?_ga=2.22076146.877218290.1585554782-1689807040.1585554782

In Anaplan Community use the search bar and search "Performance", you will get more useful links

Thanks,

Sorna Raja Prabhu

Misbah

@CommunityMember125605 Very Good Question.

Here is what can be done in order to Improve the performance if there is a model which is already built and you want to improve the performance of the model.

1. Try doing Pareto Analysis of the model. Pick top 5 modules of your model and see if you can optimize line items of these modules by changing the Summary of each line item. You also may want to look at the Dimensionality of each line item and see if you have got it right for each line item . For example if you are working on a multi dimensional module and you want to refer the parent of one of the dimension that line can be carved out and put it into separate module called system module.

2. Take the blueprint of the model and look for multiple IF ELSE statements. If you have got more than two IF ELSE conditions within a line item I would recommend breaking these and look for alternate solutions. Looksups are really helpful. Also avoid using TEXT and TEXT Joins as much as possible

3. Try to reduce the number of properties within a list and replace properties as line items in a module. There are a few exceptions where you will have to have a property like when are using Assign function, Display Name for a Numbered list, Using properties to open new dashboard etc

4. Check the user concurrency of the model. Sometimes it so happens that user concurrency takes a toll on the model performance and you have got to very careful and plan for this at the beginning of the project. However you can still go ahead and request Anaplan to perform this test for you. Note: It is a paid service.

This is the illustrative and not exhaustive list.

Anaplan's engine is very powerful and at the same time flexible enough to let you do whatever you want to do. But we follow some guidelines in order not to degrade the performance of Anaplan. It all boils down to one thing and that is how are we designing the model (PLANS) and most importantly how are we building it (DISCO)

I would recommend reading all these articles

1. https://community.anaplan.com/t5/Blog/The-Planual-Rises/ba-p/48321

2. https://community.anaplan.com/t5/Best-Practices/Data-Hubs-Purpose-and-Peak-Performance/ta-p/48866

3. Read about DISCO and PLANS - This is more of revamping kind of exercise if you are going this way.

Thanks,

Misbah

All comments

prabhu

Hi @CommunityMember125605,

You can read these link.

https://community.anaplan.com/t5/Best-Practices/Reduce-Calculations-for-Better-Performance/ta-p/33667

https://community.anaplan.com/t5/Best-Practices/Good-Practices-to-Improve-Model-Performance/ta-p/33550

https://help.anaplan.com/anapedia/Content/Calculation_Functions/CF_Optimizing_Time_Calculation_Performance.html?_ga=2.22076146.877218290.1585554782-1689807040.1585554782

In Anaplan Community use the search bar and search "Performance", you will get more useful links

Thanks,

Sorna Raja Prabhu

Misbah

@CommunityMember125605 Very Good Question.

Here is what can be done in order to Improve the performance if there is a model which is already built and you want to improve the performance of the model.

This is the illustrative and not exhaustive list.

I would recommend reading all these articles

1. https://community.anaplan.com/t5/Blog/The-Planual-Rises/ba-p/48321

2. https://community.anaplan.com/t5/Best-Practices/Data-Hubs-Purpose-and-Peak-Performance/ta-p/48866

3. Read about DISCO and PLANS - This is more of revamping kind of exercise if you are going this way.

Thanks,

Misbah

CommunityMember125605

hello, Misbah.
Thanks for you giving me detailed information!
I feel DISCO is important.

CommunityMember125605

Hello, Sorna.
Thanks for telling me some good sites.
Your reccomendation is concise and easy to understand !

Quick Links

Can you help?

Unanswered questions

Alternative of Rankcumulate
Is there an alternative to using RANKCUMULATE in Anaplan for cumulative ranking by group? The model's performance is impacted due to the use of rankcumulate. I'm looking for a more efficient approach or best practice to achieve cumulative ranking within groups without degrading performance.
Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…