The settings a workspace administrator chooses for the Model calendar create time periods. These periods become aggregation levels and options users can select in various parts of the model. 

Which time period options display for you depends on the part of the model you are in, and whether the model uses time ranges.

If you use time ranges, the set of periods you can select from depends on context. In some places the options are by time ranges, in others, you can choose from the time period superset.

The time period superset includes both time ranges and all time periods across the Model calendar and their aggregation levels. This includes time periods not contained by a time range.

For example, if you create a series of time ranges between 2018 and 2021, and then add a time range for 2023. The superset contains values for 2020 even though there is no time range for that period.

If you enable the optional aggregation levels Quarter and Half-Year, these are also part of the superset.

Changes to time ranges can affect the superset. For example, if you:

  • Add a new time range, or edit an existing one, to include periods not present in any existing time range, the new periods are added to the superset.
  • Edit a time range to remove periods, providing those periods are not in any other time range, they're removed from the superset.
  • Edit a time range to add an aggregation level that's not already in the superset, it's included.
  • Edit a time range to remove an aggregation level, where the aggregation level is not in any other time range, it's removed from the superset.

This table shows which model elements use which time period options:

Model elementTime options are determined by
Line item time scaleLine item time range
Time period formatSuperset

Versions:

  • Switchover
  • Edit from
  • Edit to
  • Bulk copy
Superset

Modules:

  • Filter
  • Compare
  • Import (except for the Selected Year setting)
Module time range
Import > Selected Year settingSuperset
Current periodModel calendar settings