1. Modeling
  2. Dimensions
  3. Time
  4. Set the model calendar
  5. Set the Weeks: 4-4-5, 4-5-4, or 5-4-4 calendar

Select Weeks: 4-4-5, 4-5-4, or 5-4-4 to select a pattern for grouping weeks into months (4-4-5, 4-5-4, or 5-4-4). 

Typically, every quarter has 13 weeks. However, as one year is not exactly 52 weeks, you can compensate for this with a 14 week quarter once in every five or six years. A 4-4-5 fiscal month and a calendar month are not same.

To set the Weeks: 4-4-5, 4-5-4, or 5-4-4 calendar type:

  1. Select Time in the model settings bar.
  2. Select Weeks: 4-4-5, 4-5-4, or 5-4-4 in Calendar Type. 

Weeks: 4-4-5, 4-5-4, or 5-4-4 options

You can set the following options:

Week Grouping into Months / Qtrs

Select the pattern for how weeks are grouped into months for each quarter.

For example, some organizations report by 4-4-5 quarters (four weeks in the first month, four weeks in the second month, and five weeks in the third). 

End of Fiscal Year is

You can set when the end of the fiscal year falls.

The options are: 

  • Last Day in Month, for example, Last Sat in Dec.
  • Day nearest to end of Month, for example, Sat nearest to end of Dec.

The option that you choose automatically adjusts the values available in Current Fiscal Year to align with your selection.

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.

Extra Week for 53-Week Year Falls in Period

Weekly calendar timescales represent 52 weeks, or 364 days in a year. The standard calendar year has 365 days, and every fourth year has 366 days. This means that the financial year is shorter than the calendar year. 

To correct this, approximately every 6 years, there are 53 weeks in the financial year. The year when you have 53 weeks is calculated for you, based on this setting, and the setting for End of Fiscal Year is.

Select the time period to which you want to add the 53rd week. 

Week Format

Select the week format:

  • Numbered, for example Week 8 FY23
  • Week Commencing, for example W/c 23 Jan 23
  • Week Ending, for example W/e 29 Jan 23

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]