Success Central

Join

Best practice model building

ChrisMcCarthy
ChrisMcCarthy
in Groups

Currently looking at additional use cases for Anaplan, including using for a 5 year planning horizon, rather than the current 24 month one. Question has come up around level of detail that wish to plant at and hence the impact on model size and looking for tips in terms of best practice when building out model

Screenshot 2023-12-07 135605.png

Example, some of the lists that are to be referenced have number of members such as below:

Reporting Segments - 108

Sub Regions - 18

Product Groups 62

Is it best to build out model using more modules and reference subsets of these lists, rather than whole lists and make model sparse unnecessarily?

Getting similar requests on creating module for reporting purposes that has all main dimensions in, which essentially creates a huge cell count of 1.6bn!

Tagged:

Comments

  • DiC
    DiC

    Hi Chris! Thanks for initiating this discussion. Our platform adoption specialist, Ryan Kohn, has reviewed this. We encourage you to focus on the Planual and PLANS standard and not just the model size. Using subsets is one way to be dense-structured. There's also using numbered lists to concatenate dimensions.

    We also recommend you review and/or post model-building questions in the https://community.anaplan.com/categories/modeling-discussions discussion forum for wider visibility where model-builders will respond quickly!

  • ChrisMcCarthy
    ChrisMcCarthy

    Thanks, I will take a look into the use of numbered lists to concatenate dimensions and post in modelling discussion forum as you suggest

Categories