1. Modeling
  2. Dimensions
  3. Time
  4. Set the model calendar
  5. Mixed time scales in a model

Model builders can set a single calendar type for a model, but different timescales can also be set for modules and line items within the model. 

Available time scales depend on the calendar type you select for a model.

Calendar typeAvailable time scales
Calendar Months/Quarters/Years

Not Applicable, Day, Month, Quarter, Half-Year, Year.

Note: Quarter, and Half-Year options are available if the Include: Quarter Totals, or Half-Year Totals options are selected in the Model Calendar.

Weeks: 13 4-week PeriodsNot Applicable, Day, Week, Month, Quarter*, Year
Note: Quarter is available if the Include: Quarter Totals option is selected in the Model Calendar.
Weeks: 4-4-5, 4-5-4 or 5-4-4

Not Applicable, Day, Week, Month, Quarter*, Half-Year*, Year

Note: Quarter and Half-Year options are available if the Include: Quarter Totals, or Half-Year Totals options are selected in the Model Calendar.

Weeks: GeneralNot Applicable, Day, Week

When line items in a module have different time scales, subsidiary views are created.

Mixed time scales and formulas

Where two line items each use a different timescale, and one refers to the other in a formula, then days aggregate into months, months aggregate into quarters, and quarters aggregate into years. You can also choose to skip levels. For example, days can aggregate into years.

If line item X has a time scale of months, and line item Y has a time scale of years, then Y=X returns the year total. However, X=Y returns nothing, because Y does not contain a corresponding value for each month. 

You can set up formulas that use the WEEKVALUE, MONTHVALUE, QUARTERVALUE, YEARVALUE, or SELECT functions to return the results that you need. For example, if line item X is in months, and line item Y is in years:

Y = XResult takes the relevant time total from X, where X has a more detailed time scale than Y, such as X in months, Y in years.
X = YShows a blank, unless the summary method is set to Formula, in which case it shows the value Y in the year totals only.
X = YEARVALUE(Y) * Seasonality %Allocates Y according to a seasonality percentage.
X = Y[SELECT:Time.FY11]Shows the value of Y for a specific year.

Note: When you use a time-related calculation function, such as WEEKVALUE or MONTHVALUE, the value returned depends on the Summary method set for the source line item.