inquiry on how to execute time ranges to minimize model size

Hi Community,

I have a question on how to minimize the model size of the client. Recently they ask to have an additional 2 Previous years on the model (which is done already). They added FY2017 and 2018. This reflects on all of their modules which greatly increased their model size. It is currently on 105GB already. But then they ask me to remove the 2017 and 2017 years on some modules that does not need 2017 and 2018. To at least decrease the size of the model (hopefully). I previously encountered time ranges but I have not personally use it yet. Can someone gave me some examples on how to execute the time range (with screen shot if possible). And with this, is it possible to decrease the model size for the meantime.?

Hope you can provide some insights on this matter.

Regards,

Accepted answers

Alexandru.Rosca

@Jsdeloria21 Time ranges is one of the best practices for keeping your model size under control.

If your model calendar now has 2017-2022 defined, that means all your modules that use time dimension will apply same time range.

First you need to ask yourself: is the entire time range really needed in all modules? do I need it only for historical data? Or I will frequently report backdated periods or do comparisons with 2017/2018 still? If the answer is to only keep archived/historical data, then you can only target those modules and apply a larger time range.

You can define it from: Model time -> Time range. You can set as many as you want to. Further on you can apply those to module line items: If you do it right, you will be able to reduce the size considerably.

Also, is a very good practice to review all the modules and see if all line items in the model require to apply a time dimension or if they require to apply all dimension of the module. Check your summary methods, duplicate calculations (can you use line item subsets for those?). Make use of the system modules to avoid multiple reference in each module, etc.

Here are some great resource examples:

https://community.anaplan.com/t5/On-Demand-Courses/Reducing-Model-Size-Introduction-to-Sparsity/ta-p/27718

https://community.anaplan.com/t5/Anaplan-Platform/Model-Optimization/td-p/49389

All comments

Alexandru.Rosca

@Jsdeloria21 Time ranges is one of the best practices for keeping your model size under control.

If your model calendar now has 2017-2022 defined, that means all your modules that use time dimension will apply same time range.

Here are some great resource examples:

https://community.anaplan.com/t5/On-Demand-Courses/Reducing-Model-Size-Introduction-to-Sparsity/ta-p/27718

https://community.anaplan.com/t5/Anaplan-Platform/Model-Optimization/td-p/49389

whitby

Hi @Jsdeloria21

You can use time ranges to reduce the model size as you describe. The anapedia actually has some great articles on this with step by step guides and 'how-to's

Time ranges - Anaplan Technical Documentation

Work with time ranges - Anaplan Technical Documentation

The crux of it can be summarised as follows:

- You create the time ranges in the time range panel (new):

- Select the years you want as well as any summaries required (if it is not used for reporting you typically don't need any summaries - particularly as they will increase the # cells used & thus model size)

- You then have to apply the range to the modules (and the individual line items):

Jsdeloria21

@Alexandru.Rosca Appreciate the answer you have provided me.

Thank you.

Regards,

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…