1. Modeling
  2. Dimensions
  3. Time
  4. Time ranges

Time ranges are a type of dimension that are used in modules and line items to enable the analysis of time-based data. You can restrict the range of periods into which data can be entered or displayed, over a time period longer or shorter than the main timescale.

Note: This functionality is not available in Polaris. Polaris is currently in early access and is only available to some users.

Each time range is an independent entity with a Start Period and a defined Number of Periods in years. These are measured in units of a fiscal year and are independent of the Model Calendar. They are not locked to the current fiscal year, or to the number of past or future years configured for the Model Calendar.

The start point of a time range is tied to the Fiscal Year Start Month of the Model Calendar. If this value is changed, all time ranges will realign accordingly.

You can create as many time ranges as needed and define how the data is summed or aggregated.

Benefits of Time Ranges

There are a number of advantages in using time ranges in your modeling activities.

Less sparsityThe calculation engine can ignore any empty cells, and it is not necessary to perform aggregations in time or in other dimensions.
Less workaroundsIt’s often impractical to expand the model calendar to handle all time periods that may be required. In this case the model builder may employ custom time lists to handle the differing ranges of periods which can have undesirable consequences.
More accessible viewsThey give independent, finer-grained control of the available aggregations. Currently, if you enable Quarter totals for the model calendar, they are calculated for all line items that vary by time, and appear in all module views.
Greater time period rangeThe window for the current model calendar (in 2018) is limited to 81 years; FY1992 to FY2073 (2012 - 20 years to 2022 + 50 years). The maximum range in any one model is 71 years (Current Fiscal Year - 20 + 50 years). The maximum extent for a time range is 98 years; FY1981 to FY2078.
Multiple time rangesEach time range allows independent aggregation of the line items within the span of the time range.
ALM supportTime ranges are supported by Application Lifecycle Management (ALM) to enable you to synchronize your data across environments.

Known limitations of time ranges

Time ranges have some known limitations. They:

  • can only use units of whole years.
  • do not support the Weeks: General calendar type.
  • do not vary by version, or by any other list.
  • cannot be marked as production data (ALM).
  • have a fixed span, for example, they do not update with the Current Period.