Is there any way to set up a rolling 18-Months in Anaplan, as time dimension?
Right now we are able to set up 2 full fiscal years, to get 18-Months for forecasting.
But at the 7th month of the current fiscal year, we need to have 1 more fiscal year, which will lead us to have total 3 full fiscal years in Anaplan's time dimension.
That will definitely blow up the size of entire model. We have currently just one fiscal year's data, if we have 3 fiscal years, then our model size will be 3 times of our current model. That is why I would like to see if there is any possibility to have a rolling 18-Months settings in Time, and we could reduce our sparsity.
At the moment the only way to achieve this is to create a "fake" time dimension which is a normal list used as a proxy for the timescale. The advantages are, as you mentioned, space saving, but the disadvantages are added complexity, and the lack of "native" time functions such as cumulate, previous etc.
However, our product team are developing new functionality for time ranges which will help you in this case (along with many, many others!!).