CommunityMember125605
Occasional Contributor

How to improve Anaplan performance

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/...

2 ACCEPTED SOLUTIONS

Accepted Solutions
prabhu
Community Boss
Misbah
Moderator

@CommunityMember125605Very Good Question.

这是可以做些什么为了提高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 theSummaryof each line item. You also may want to look at theDimensionalityof 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

View solution in original post

4 REPLIES4
prabhu
Community Boss
CommunityMember125605
Occasional Contributor

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

@CommunityMember125605Very Good Question.

这是可以做些什么为了提高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 theSummaryof each line item. You also may want to look at theDimensionalityof 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

CommunityMember125605
Occasional Contributor

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