1. Modeling
  2. Dimensions
  3. Time
  4. Model Calendar
  5. Use Mixed Timescales

Although a single calendar type is defined for a model in Model Settings > Time > Model Calendar, it is possible to have mixed timescales within a model. Each module and each line item can use its own timescale, however, the choice of timescale depends on the primary calendar type:

Calendar Type Timescales Available
Calendar Months/Quarters Years Not Applicable, Day, Month, Quarter, Years
Weeks: 4-4-5, 4-5-4 or 5-4-4 Not Applicable, Day, Week, Month, Quarter, Years
Weeks: General Not Applicable, Day, Week

Examples of Mixed Timescales

 

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

If line item X has a timescale of months and line item Y has a timescale of years, then Y=X will return the year total. However X=Y will return nothing because Y contains no corresponding value for each month. Formulas using the WEEKVALUE, MONTHVALUE, QUARTERVALUE, YEARVALUE or SELECT functions can be set up to return the result required. For example, if X is in months and Y is in years:

Y = X Result takes the relevant time total from X, where X has a more detailed timescale than Y, such as X in months, Y in years.
X = Y Shows a blank, unless Summary method is set to Formula, in which case it will show the value Y in the year totals only.
X = YEARVALUE(Y) Will show the value of Y in each month.
X = YEARVALUE(Y)/12 Will allocate the value of Y evenly over months.
X = YEARVALUE(Y) * Seasonality % Will allocate Y according to a seasonality percentage.
X = Y[SELECT:Time.FY11] Will show the value of Y for a specific year

Important When you use any of the time functions, such as WEEKVALUE or MONTHVALUE, the value returned depends on the Summary Method set for the source line item.