Allow Time Ranges to move dynamically in relation to the Model Calendar


Currently when creating a time range you select the start of the range and then the number of periods. When you come to roll over the model to a new year those Time Ranges need to be reviewed to see whether they also need to be rolled forward. What I would like is the ability to decide whether the start of a time range is linked to the start of the model calendar. So if my model calendar is FY19 I might create a time range History which I want to be 5 years prior to the start of my model calendar. So I tick a box for "Dynamic" and then enter a number of -5 to determine the start of my time range. A negative indicates a date before the start of my model calendar a positive after and zero means it is aligned but may contain a different number of years or summary options. When a model is moved forward a year then any Dynamic Time Ranges would be automatically updated.

43 votes

In Review · Last Updated


  • Miran
    Status changed to: In Review
  • Rebecca
    Status changed to: In Review
  • Great idea Nick, definitely a worthwhile requirement.

  • This would be nice to have. Rather than updating the model calendar, and each individual time range, having an option to be dynamic, and update with the model calendar would be nice. 

  • This is also related to getting "Today's date" via a function within the model.

  • Hi All, is there any update on this topic?

    Thanks for helping.


  • nickealvarez
    edited November 2023

    Hello, is there any update on whether this enhancement is being prioritized?

    I ask as I am currently rolling forward a model that contains several time ranges, each which takes several minutes to update forward for the next fiscal year. 😅

  • Same here.

    That the main reason we arent using time ranges at all cost, it s just not maintanable at enterprise scale.

    So our recommendations for time ranges to be great :

    - dynamic ranges options as suggested above so that they can move with the main time.

    - option to have fiscal year changes as production data (please this is really annoying for everyone)

    - time subsets (who needs a 2 full years when we just need 18 months ?)

Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!