Caution! Changing the current fiscal year will effectively start the new year with a clean, unpopulated model. If you want to keep the data for the previous year, make sure you take a copy of the model or set the Number of Past Years to 1 in the Time tab, before changing the current fiscal year.
The Number of Past Years can be set to any number up to 50 (after the current fiscal year). If you attempt to extend the timescale beyond the 50-year threshold, a message will display.
Weeks: 4-4-5, 4-5-4 or 5-4-4
For this timescale, select a pattern for grouping weeks into months (4-4-5, 4-5-4 or 5-4-4). The Week Format can be:
You will also need to state the last day of the financial year. For example, you might choose a weekly 4-4-5 timescale with the financial year ending on the last Saturday in December.
Weeks: General has no concept of financial years — it's simply a number of weeks. Consequently no Year, YTD or YTG subtotals are calculated. However, the Current Period can still be used in calculations using CURRENTPERIODSTART and CURRENTPERIODEND.
Weeks: 13 x 4-Week Periods
Timescales can consist of 13 4-weekly periods: you must define which quarter contains 3 periods and which contains 4.
To define the number of periods in a quarter, in Model Settings click Time and select the Quarter Totals check box. Choose one of the options for quarter lengths to indicate the number of 4-week periods in each quarter: e.g. 3-3-3-4 provides 3 4-week periods in the first three quarters and 4 4-week periods in the last quarter.
Use Mixed Timescales
Although a single calendar type is defined for a model in the Time tab in Model Settings, it is possible to have mixed timescales within a model. Each module and each line item can have its own timescale, however, the choice of timescale depends on the primary calendar type:
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
Not Applicable, Day, Week
Examples of Mixed Timescales
Where two line items each have 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 could aggregate directly into years if required.
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
Caution! 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.
Set up a 53-Week Year
Weekly timescales represent 52 weeks (4-4-5 or 13 4-weeks) or 364 days in a year (52 *7 =364). This is one short of the 365 days in a calendar year. Consequently, the financial year end tends to drift earlier and earlier in the year until eventually it is possible to fit in an extra 53rd week (approximately every 6 years). Leap years complicate the picture by providing an extra day every fourth year. To define when the 53-week year occurs, it is sufficient to set the day of the week that the financial year ends and the period in which you would like the 53rd week to be slotted in. Anaplan calculates the years in which the 53rd week is due.
In the Time tab in Model Settings, set the day for the end of the fiscal year (for example, Last Sunday in September) and the period in which the 53rd week is to fall (for example, Period 13 in a 13 4-week timescale). This is sufficient to define which years contain 53 weeks.
Define the Fiscal Year Label
Frequently, the fiscal year does not coincide with the calendar year: Jan 1 to Dec 31. If you choose to start and end the fiscal year out of step with the calendar year, the system default aligns the Fiscal Year Label with the calendar year in which the end date of the fiscal year falls.
A radio button enables you to leave the Fiscal Year Label aligned with the end of the fiscal year or to change to align it with the start of the fiscal year. This option is also available for the Weeks: 4-4-5, 4-5-4, or 5-4-4 and Weeks: 13 4-week Periods calendar types.
Where a weeks-based timescale runs close to the start and end of a calendar year, the system aligns the fiscal year label in accordance with these rules:
End week of the fiscal year: The calendar year that contains the first day of the last week of the fiscal year will be used as the Fiscal Year Label.
Start week of the fiscal year: The calendar year that contains the last day of the first week of the fiscal year will be used as the Fiscal Year Label.
In some situations, if you select the fiscal year label to be aligned with the start week of the fiscal year, the final day of the first week of the fiscal year can fall in the same calendar year as the end date of the fiscal year. This example shows a Weeks: 4-4-5, 4-5-4, or 5-4-4 calendar type and the end of the fiscal year has been set as the last Saturday in Dec 2015. This means the first day of the first week of the fiscal year is Sunday Dec 28 2014. But the final day of that first week - Saturday Jan 3 2015 - falls in 2015 and the fiscal year label when aligned with the start of the fiscal year is FY15, not FY14, and the same as when the fiscal year label is aligned with the end of the fiscal year:
Year-on-Year Comparisons using Multi-Year Timescales
Year-on-Year (YoY) comparisons can be developed using line items subsets and the COLLECT function to avoid creating a YoY calculation for each and every line item. The process creates a separate module that uses a line item subset based on the line items in a data source module.
A YoY comparison can be set up for any number of years and any number of line items using just 3 formulas:
The COLLECT function to collect source data.
The POST function to post results on 12 months for comparison.
A YoY% calculation to calculate the current year values as a percentage of last year's. The YoY% uses a summary method of formula to correctly calculate quarterly and annual totals.
The advantage of using a line item subset as a hierarchical dimension is that you're free to do whatever calculations are needed within the line items and it's maintenance free. When you add line items to the source module, they will automatically be added to the line item subset.
Versions explains how to work with versions for YoY comparisons and for variance reporting across model timescale.
Change the Date Format
The date format is changed by altering the preferred language in the browser. Consequently, the format of the date is controlled by individual users based on the language they set in their browser.
The steps to change Date Format vary by browser and version — refer to the browser Help for further assistance.
You should also ensure that the computer's system locale is set to the relevant location.
In Windows, go to Control Panel > Clock, Language, and Region > Region > Location
In OS X go to System Preferences > Language & Region > Region
A Restart is required for these changes to take effect.