1. Modeling
  2. Dimensions
  3. Time
  4. Model Calendar
  5. Change the Fiscal Year Label

You can change the Fiscal Year Label from FY to a different two-character string. This option can help if a model uses a different time scale to the fiscal year, for example, the calendar year.

Where possible, use the same Fiscal Year Label for related models to ensure consistency.

You configure and change the Fiscal Year Label for each model individually.

Before you change the Fiscal Year Label, consider the potential impact on any imports, exports, or filters in your model. Use ALM to test the impact of any changes to the label.

The Fiscal Year Label displays in summaries for any modules that use the Time dimension. You can change the Fiscal Year Label if you use a Calendar Type of:

  • Calendar Months/Quarters/Years
  • Weeks: 4-4-5, 4-5-4, or 5-4-4
  • Weeks: 13 4-week Periods

You cannot change the Fiscal Year Label if you select Weeks: General as the Calendar Type.

The Model Calendar, within Model Settings > Time. The Fiscal Year Label field is selected, and contains CY, instead of the default FY.

To change the Fiscal Year Label:

  1. Open Model Settings > Time.
  2. Select the Fiscal Year Label field.
  3. Overwrite the default FY label with your desired label.
    The label must contain two characters and is mandatory.
  4. Click Apply.
    A dialog displays.
  5. Click OK.
    The Fiscal Year Label updates in the model.

Effect of Fiscal Year Label on filters

Avoid explicit time references such as Time.‘Q1 FY20’ or Time.‘FY20’ in your filters. If you use such references, you need to update your filters when you change the Fiscal Year Label.

You can avoid this issue if you use a module that contains the Time dimension and Boolean-formatted line items for your time filters. In many cases, this is also more efficient and requires fewer manual updates of filters and formulas.

Effect of Fiscal Year Label on imports

If you change the Fiscal Year Label, you should consider how it affects your imports. Whether your import is from an uploaded file, or from another model, the same considerations apply.

If you import into a module that uses Months for the Time Scale field, there's no impact when you change the Fiscal Year Label.

However, if you import into a module that uses one of the time scales below, you may need to reconfigure your imports:

  • Weeks
  • Periods (if you have 13 4-week Periods selected as the Calendar Type)
  • Quarters
  • Half Year
  • Year 

For example, take a module that uses one of the above time scales and the Match on names setting for an import. In this case, the import fails, and the message Invalid date or timescale identifier displays.

To fix imports, Use the Custom fixed-position pattern import option when you map the Time dimension. Alternatively, change the time label in the source data.

The Time tab within the Import dialog. The Custom fixed-position pattern section at the bottom of the dialog is highlighted.

Effect of Fiscal Year Label on exports

If you change the Fiscal Year Label, it also changes the time period labels in any exports you perform.