Changing Your Fiscal Year
By default, Medecision Analytics calculates the beginning of the fiscal year as January 1st. You might need to express your company's date fields according to another fiscal month, for example, April 1st. Medecision Analytics enables you to easily shift your fiscal calendar to start on a different month, according to your company's requirements.
This can be defined at the:
System level, by the Sys Administrator
Live and/or model level by the Data Admin and Data Designer
For example, you can support one fiscal calendar month for your system, for example, January 1st.
When you change the fiscal calendar, it affects how time is calculated in your dashboard. You also receive an indication, for example when filtering your widgets and dashboards by time, through the FY tag.
Note - Limitations:
Filters created with non-default Fiscal Year enabled do not automatically update their titles after disabling the Fiscal Year.
Fiscal Year support for Live models requires the Analytical Engine to be enabled.
The MySQL and MemSQL connectors are currently partially supported by the AE, but the AE is not enabled for them by default. Full AE support is currently in development for MySQL; once complete, the AE will be enabled for it by default.
The Oracle connector is currently not supported by the AE at all. The AE cannot currently be enabled via the UI for Oracle. Support for Oracle in the AE is planned for the future.
Once you have defined your fiscal year, the next widget load generated is automatically affected. Therefore, there is no need to rebuild or publish the model.
Date Level | Effects |
Year | Changes the calendar year to fiscal. By default, the name reflects the year in which it ends. For example, if the fiscal year starts in April, the year for the date June 1, 2014 would be shown as FY 2015. |
Quarter | Changes the calendar quarter to that of the quarter in the fiscal year. For example, if the fiscal year starts in April, the quarter for the date June 1, 2014 would be Q1. |
Month | Not affected by fiscal year settings. The calendar month is the same as the fiscal month. |
Week | Changes the calendar week to the week of the fiscal year. For example, the first week of the fiscal year for 2015 starts at the beginning of April 1. |
Day/Minute/Hour | Not affected by fiscal year settings. |
Formatting Fiscal Dates
When you apply fiscal years, the default format for your dates is 2018 FY for years or Q1 2018 FY for quarters.
You can customize the format of the date through placeholders such as 'y' and 'p' where 'y' represents the year and 'p' the previous year.
The examples below illustrate how you can format your dates:
2017/18: yyyyp/yy
17/18: yp/yy
FY17/18: FY yp/yy
Q1 2018 FY: Q yyyy FY
By default, when fiscal years are applied, Medecision Analytics adds FY at the end of the year. If you make any changes, Medecision Analytics will no longer add the FY automatically, and you must define it with the placeholder FY, in the location you want it displayed, as shown above.
To format your fiscal dates:
On the Dashboard, click the Pencil (Edit) button
that appears in the top-right corner of a widget with a date dimension.
Select the Calendar icon.
3. Select the relevant time period and enter the placeholders, in the format you want displayed in your widget. A preview of the custom format is displayed below.
4. Click OK. The format of your dates is updated in the widget.