Time Ranges vs Model Calendar

Hello,

I had a technical question around Time Ranges. Let's say my Model Calendar is set to FY21 Jan-Dec, I have 2 past years and 2 future years.

I have some planning and assumptions modules that are only relevant for me for the Planning period. So I develop time ranges to save sparsity and reduce cell count in my model.

What happens to Time Ranges when I advance the Model Calendar and I arrive to the next Fiscal Year/Planning Cycle, do I also have to update my Time Range settings?

Thanks,

Daanish

Accepted answers

rob_marshall

@DaanishSoomar

Yes, model calendar and time ranges are independent of each other.

Rob

All comments

rob_marshall

@DaanishSoomar

Yes, model calendar and time ranges are independent of each other.

Rob

DaanishSoomar

Thank you @rob_marshall!

CommunityMember126793

@DaanishSoomar @rob_marshall

writing on back of the solution as just wanted to clear my doubt.

@DaanishSoomar snippet from your query --> "So I develop time ranges to save sparsity and reduce cell count in my model.". Lets say you got a Time Range of FY18.

And now when you need to push your TIME SETTING (Model Calendar) forward as next FY i.e. FY22.

Why do u need to change your "Time Range" as Time Range got developed specific to a range i.e. FY18 (in above case).

Can you help in clearing the understanding as to WHY "Time Range" require to change?

rob_marshall

@CommunityMember126793

Time Ranges are completely independent of the model calendar. If you move the model calendar forward, you could a) do nothing to the Time Range and keep it at FY18 or b) would need to move it up to FY19.

Does that help clear it up?

Rob

CommunityMember111277

Hi @rob_marshall

Is there a way to move data from respective Time Range to a Model calendar? If no, then what can be an alternative

If its possible, then what should we use as formula as LAG doesn't work I guess

What is the real purpose of Time Range apart from storing historical data? How can we use these historical data in our current model calendar

Thanks

rob_marshall

@CommunityMember111277

So yes, you can move data from one time range to another or a time range to model calendar or vice versa, you would just need to map the data in a SYS model to tell it where to go.

As for what are Time Ranges used for, you are able to create different "Time Ranges" for modules or even line items whereas we were not able to do that previously (it was always one giant Model Calendar). In doing this, you are now able to have more densely populated modules because you are only using the Time members that you need. For more information, you can follow this link.

YEAnaplanViseo

Hello,

Can you explain to me in a short phrase the benefits of time ranges and when we use it?

Thanks in advance.

Quick Links

Can you help?

Unanswered questions

Can we disable Create page button from the UX page
I want to disable the [create page] button for the end user from the dashboard. The end user can create a page or worksheet to link to the module to edit the data. can anyone please give some suggestion? Thx…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
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…