If you want to create a subsidiary view, you can apply different time scales to line items in a module. Subsidiary views show subsets of data.

You can set the time scale for either your entire model in Time in the model settings bar, or different time scales for line items in a module. For example, if the default dimension is measured by Year, you can create a line item that has a time scale of Month.

To apply a different time scale to an individual line item:

  1. Select Modules in the model settings bar.
  2. Select the module that contains the line item you want to edit, then select Open.
  3. Select Blueprint .
  4. Select an option for your chosen line item in the Time Scale column.

When you change the time scale for a line item, a subsidiary view is automatically created.

If two line items have a different time scale, and one refers to the other in a formula:

  • Days sum into months. 
  • Months sum into quarters.
  • Quarters sum into years. 

If required, you can skip different time levels. For example, days can sum 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 a blank value, as Y contains no corresponding value for each month (X).

You can create formulas with the following functions to return a result:

In the table below, the X and Y line items have the same time scales as above.

Example formulasExplanation
Y=XThe formula returns the relevant time total from X, where X has a more detailed timescale than Y.
X=YThe formula returns a blank result, unless the Summary method is set to Formula, in which case it will show the value Y in the year totals only.
X=YEARVALUE(Y)The formula returns the value of Y in each month.
X=YEARVALUE(Y)/12The formula evenly allocates the value of Y over months.
X=YEARVALUE(Y) * Seasonality %The formula allocates Y according to a seasonality percentage.
X=Y[SELECT:Time.FY11]The formula returns the value of Y for a specific year.