1. Modeling
  2. Dimensions
  3. Time
  4. Time Ranges
  5. Work with Time Ranges

To set up time ranges, you must be a workspace administrator and the model must not be in Deployed mode. You can create, edit, or delete time ranges in the Model Settings > Time > Time Ranges tab.

Name time ranges

Each time range must have: a unique name that is a maximum of 60 characters long; and not have an underscore at the start or end of the name. This name is visible to users when they access Pivot.

The name of a time range should include the date range and aggregation, for example, FY19-FY20 or FY18-FY22 with Qtrs.

Time range length

The length of a time range is set in fiscal years. The Start Period is the first year in the time range, so a time range that starts in FY2018 with a length of 1 year will span FY2018 only. You can select any year within the system constraints (1981 to 2078) as the start period. If the start period is FY1981, the time range can have a maximum of 98 years; but only one year if the start period is FY2078.

In these articles, you can learn how to: