Model Sparsity Principles & CoE Best Practices

Community Manager

Re: Model Sparsity Principles & Center of Excellence Best Practices

This session will wrap up in one hour. Please submit your final questions for Mark as soon as possible! 

Message 11 of 23
Certified Master Anaplanner

Re: Model Sparsity Principles & Center of Excellence Best Practices

Hello Mark,

We often use subsets to reduce model sparsity. And some of those subsets can be described using formula.

Does Anaplan team have any plans to make it possible to write formulas for subsets? Currently we use actions to automate subsets maintenance.

Thanks & Regards,

Hayk

Tags (1)
Message 12 of 23
Certified Master Anaplanner

Re: Model Sparsity Principles & Center of Excellence Best Practices

Maintenance of subsets via calculations in modules set up to maintain the subsets through imports is currently a best practice. Directly maintaining subsets by formula within a list is not currently on the immediate product roadmap. We encourage you to post Request For Enhancements RFE.
Message 13 of 23
Contributor

Re: Model Sparsity Principles & Center of Excellence Best Practices

Hi,

Can you provide some more insights on new UI features coming in next releases?

Thanks

Ravi

Ravi
Message 14 of 23
Certified Master Anaplanner

Re: Model Sparsity Principles & Center of Excellence Best Practices

Ravi
Best place to monitor upcoming features is here in Community. Also, submitting Requests For Enhancement and participating in Early Adopter programs is available.
Message 15 of 23
Occasional Contributor

Re: Model Sparsity Principles & Center of Excellence Best Practices

Hello Mark,

We have a module is dimensioned by weeks and a list of programs (say 1,000 programs in the list). However, half of the programs only have data in the first 26 weeks and the other half only has data in the rest of the weeks. If the module is dimensioned by the weeks and the list, it would be very sparse.

What's your recommendation to reduce sparsity in this case?

Thank you!!
Amy
Message 16 of 23
Certified Master Anaplanner

Re: Model Sparsity Principles & Center of Excellence Best Practices

There are a view options to consider: 1) subset the programs by 1st half and 2nd half and use the subsets separately to manage sparsity. 2) Consider time ranges which is similar, limited to full years only, and  won't give you the flexibility of subsets, i.e. multiple time ranges will have to be maintained. 3) If the program module is by time and is primarily an input or plan/actual data module how data load is structured will impact the degree of sparsity over time. Are all of the programs in populated in the timescale, or could a numbered list be used to reduce the program list size.

Message 17 of 23
Certified Master Anaplanner

Re: Model Sparsity Principles & Center of Excellence Best Practices

Hi Mark,

Is there any tool being built which can indicate modules which has high sparsity. This should help saving time by reducing the analysis time in each modules.

Thanks,

Sheethal N

Message 18 of 23
Certified Master Anaplanner

Re: Model Sparsity Principles & Center of Excellence Best Practices

Hi Sheethal,
Short answer is no, there isn't a tool available to determine sparsity. In an Anaplan model, every cell is assumed to consume server memory.  High sparsity is inferred through an analysis of the dimensional intersections which are not intended or are not populated. The best technique for sparsity analysis is to review the subject model's largest modules and determine the inferred sparsity in those largest modules.

Message 19 of 23
Highlighted
Contributor

Re: Model Sparsity Principles & Center of Excellence Best Practices

Is there audio because I can't find a way to connect?  I don't have a specific question but wanted to listen to the questions and answers.  Thanks.

Message 20 of 23