1. Modeling
  2. Dimensions
  3. Time
  4. Time ranges
  5. Use time ranges in modules or line items

Workspace administrators can apply time ranges to modules or line items.

Time Ranges and Modules

When creating a new module, the model calendar is offered as a default for the time dimension.

To view the available time ranges, drag Time out of the Columns pane and into Lists and Roll-ups: the time ranges are listed as children of Time (the Model Calendar).

If time (time range or model calendar) is used as a dimension of a module, granularity will be set to the default for the calendar type – months for Calendar Months/Quarters/Years, and weeks for the two weekly calendar types.

Any line items created will have the same time dimensionality as the module. Any line items subsequently added to a module will default to the time dimensionality at the module level.

Note: Be aware that if you change time dimensionality at module level, the change will not be automatically inherited by line items.

Time Ranges and Line Items

Line items are used to store calculations, reference lists, or even other line items. The 

Time ranges follow existing rules for subsidiary views: a subsidiary view will be created for any line item whose dimensionality differs from module-level dimensionality in any respect.

If a line item has a quarter timescale, then quarter totals should be enabled at module-level to get a correct overall view.

Line item dimensionality

In Modules , in the Line Items tab, line items display two time-related columns: Time Range and Time Scale:

  • Time Range specifies the extent of the time range. The options displayed are: Not Applicable (in which case Time Scale is also Not Applicable), Model Calendar, or time ranges.
  • Time Scale specifies leaf-level granularity of line item data. Valid settings depend on two things: which aggregation levels have been chosen for the selected time range; and the Calendar Type (for example, Week is not available with a Calendar Months timescale).