1. Modeling
  2. Dimensions
  3. Time
  4. Set the model calendar
  5. Set the Calendar Months/Quarters/Years calendar

All model calendars are set to Calendar Months/Quarters/Years by default. Use this calendar type for monthly and weekly timescales.

To set the Calendar Months/Quarters/Year calendar type:

  1. Select Time in the model settings bar.
  2. Select Calendar Months/Quarters/Year in Calendar Type.

Calendar Months/Quarters/Years options

You can set the following options:

Fiscal Year Start Month

Define the month when the fiscal year starts. If you change this from the default (Jan), you can also select the Fiscal Year Label is aligned with option: End Month of the Fiscal Year or Start Month of the Fiscal Year.

Fiscal Year Label

The Fiscal Year Label appears in modules that use the Time dimension. The default is FY

You can change the label if the model timescale does not represent your fiscal year. For example, you can change it from FY to CY if the model uses the calendar year. The length of the label is two characters.

The Fiscal Year Label is mandatory. Use the same Fiscal Year Label If you have related models to ensure consistency.

If you change the Fiscal Year Label, be aware of the impact on any imports, exports, or filters in your model. Try changing the Fiscal Year Label in a development model first so you can check that your imports and exports work correctly.

Fiscal Year Label is aligned with 

Align the Fiscal Year Label with the end month or start month of the fiscal year. Use this option when the fiscal year does not coincide with the calendar year of January 1 to December 31.

For Calendar Months/Quarters/Years, the options are:

  • End Month of the Fiscal Year.
  • Start Month of the Fiscal Year.

For Weeks: 4-4-5, 4-5-4 or 5-4-4, and Weeks: 13 4 week Periods, the options are:

  • End Week of the Fiscal Year: the calendar year that contains the first day of the last week of the fiscal year.
  • Start Week of the Fiscal Year: the calendar year that contains the final day of the first week of the fiscal year.

Current Fiscal Year

If you change the Current Fiscal Year, the new year starts with a clean, unpopulated model. If you want to keep data from previous years, before you change the model, either: 

  • Copy the model.
  • Set the Number of Past Years to 1 or more, depending on how many years of data you want to keep.

Number of Past Years

You can set this option up to 20 years into the past. Use the smallest timescale possible, as each additional year substantially increases the size of the model. Use Time Ranges for longer periods.

Number of Future Years

You can set this option up to 50 years into the future. Use the smallest timescale possible, as each additional year substantially increases the size of the model. Use Time Ranges for longer periods.

Current Period

You typically set Current Period to the last time period for actual version data.

A benefit of setting Current Period is that you can refer to it in formulas instead of hard coding the specific time period. For example, you could use:

Revenue.Data[SELECT: TIME.'Current Period']

You can also use these functions:

If Current Period is not set, the formula returns a blank value.

You can update the Current Period via the Update Current Period action, as well as the Model Calendar. This lets you set the current period using a line item with a Time Period data type, and import the Current Period from a data hub.

Include

Quarter Totals

Includes the Quarter Totals summary in the Time dimension. For example, Q1 FY22. If you select Quarter Options, you can also select Quarter for a module or line item in the Time Scale column.

Half-Year Totals 

Includes the Half-Year Totals summary in the Time dimension. For example, H2 FY22. If you select Half-Year Totals, you can also select Half-Year for a module or line item in the Time Scale column.

Half-Year Totals is not available with the Weeks: 13 4-week Periods calendar type.

Year To Date Summary

Year To Date (YTD) is used with the Current Period. YTD is added as an extra summary period for the year that contains the Current Period.

For example, if the model calendar is set to Jan 2020 - Dec 2021, and the Current Period is June 2021, the YTD column is added as a summary period for 2021. The YTD column shows you the summary of the data from Jan 2021 - Jun 2021.

If you select this option, you can use it with the SELECT formula. For example, you can apply this expression to a line item:

Source line item[SELECT: TIME.YTD]

Year To Go Summary

Year To Go (YTG) is used with the Current Period. YTG is added as an extra summary period for the year that contains the Current Period.

 For example, if the model calendar is Jan 2020 - Dec 2021, and the Current Period is June, the YTG column shows you the summary of the data from July 2021 - Dec 2021. 

If you select this option, you ca use it with the SELECT formula. For example, you can apply this expression to a line item:

Source line item[SELECT: TIME.YTG]

Total Of All Periods

Displays the total of all the periods in the All Periods column. If you select this option, you can use it with the SELECT formula. For example, you can apply this expression to a line item:

Source line item[SELECT: TIME.All Periods]