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,
Best Answer
-
@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/Anaplan-Platform/Model-Optimization/td-p/49389
0
Answers
-
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):
0 -
0
