Model Optimization

Highlighted
Contributor

Model Optimization

Hi Experts,

 

I am trying to optimize the model size.

 

Can you please suggest me the main ways to reduce the size.

 

Thanks and regards,

Mahesh

8 REPLIES 8
Highlighted
Master Anaplanner/Community Boss

Re: Model Optimization

@UMAMAHESH 

Where to start

1. Summary options - Look to turn those off whenever possible

2. Look for line items that have more dimensions than are needed for calculations

3. Do you need all of the detail in some multi-dimensional modules?

4. Do you have modules / line item that are not used?

5. Could you use subsets instead of full lists for large lists?

 

A lot of the above has been articulated in various of my posts.  If you go to this page (or the Planual) there are links to most of them

https://community.anaplan.com/t5/Best-Practices/PLANS-This-Is-How-We-Model/ta-p/33530

 

I would also read the blog on sparsity

https://community.anaplan.com/t5/Blog/The-Truth-About-Sparsity-Part-1/bc-p/44584

https://community.anaplan.com/t5/Blog/The-Truth-About-Sparsity-Part-2/ba-p/44736

 

One should not reduce the size just because it is large per se.  Size and performance are not related.  Small models can (and often do) perform worse than large models because of the issues raised in my posts

 

If you think you will need some help, talk to your Business Partner about our Model Review Accelerators

 

David

Highlighted
Contributor

Re: Model Optimization

Hi David,

 

Thank you, I am checking line items and modules not using.

 

I am trying to adjust the formula.

 

Could you please suggest me on below points,

1. How can I find a summery line item not required to line items?

2. Please explain in brief regarding summery.

 

Regards,

Mahesh

Highlighted
Master Anaplanner/Community Boss

Re: Model Optimization

Have a read of the referenced articles, specifically Reduce calculations for better performance

 

In terms are are they needed:

1. Look for line items not referenced by anything and that are not visible on dashboards

2. Look for "detail" to "detail" calculations - often the source can have the summaries turned off

3. Do you need summaries on both Lists and Time

 

David

Highlighted
Contributor

Re: Model Optimization

Hi David,

 

Thank you for your reply.

 

I know these are basic questions. it will be helpful for me.

 

Can you please explain or suggest an article on the below points.

1. What is the Summery in line item?

2. Why summery line items consume high space?

3. what points should consider before changing the summery? 

4. I read your article regarding sparsity. Is it possible to apply the sparsity concept in Live models? 

 

Could you please share your views on the above points.

 

Regards,

Uma

Highlighted
Master Anaplanner/Community Boss

Re: Model Optimization

Highlighted
Master Anaplanner/Community Boss

Re: Model Optimization

@UMAMAHESH 

 

1. What is the Summery in line item? Summary is the built in feature in Anaplan (Blueprint mode) which tells the system if the numbers need be aggregated, averaged etc when the user navigates through hierarchy or time dimension.

2. Why summery line items consume high space? When you Keep summary as SUM, by default Anaplan understands that it has to aggregate the numbers and the cells where these numbers stay remains open and your number of cells increase - that's why you see the increase in size when you keep Summary on SUM

3. what points should consider before changing the summery? Only one point - whether or not you want to aggregate the numbers. If you don't want you can change the summary to None

4. I read your article regarding sparsity. Is it possible to apply the sparsity concept in Live models? If your Live Model is in Deployed state you anyway can't do that. But You can always optimize the model at any stage provided you know the model really well. It shouldn't happen that in order to optimize the model you actually take the functionality away from the business. 

Hope it helps!

Misbah

Highlighted
Master Anaplanner/Community Boss

Re: Model Optimization

Summary area of a line item, it is in the Blueprint section.

 

2019-07-26_15-51-00.png

 

For more information about the blueprint, please follow this link:

https://help.anaplan.com/anapedia/Content/Modeling/Build%20Models/Blueprint.html?_ga=2.180335012.163...

 

Thanks,

 

Rob

Highlighted
New Contributor

Re: Model Optimization

@UMAMAHESH

I think most of model optimization ways are already explained in previous messages.
But in case of a multidimentional module were suppose you have more than 10 line items, where 5 line items are catering to 1 logic and another 5 to other logic than in that case some users create a line item in between those 5 line items just for reference purpose to segregate between two logics.
Wherever such line items is used , you can make format to No Data , thus your cell count for that line item will zero and no space will be consumed.
Hope it helps !!

Ronak