How to set the FiscalYearOffset property for any Spotfire user group.

How to set the FiscalYearOffset property for any Spotfire user group.

You can set the starting month for the calculation of a fiscal year. This property can be set for any Spotfire user group, including Spotfire's default "Everyone" group.

Resolution

Steps to set the fiscal year offset property: Open the TIBCO Spotfire Analyst/Client and select Tools > Administration Manager.

Select the "Everyone" group or any other specific Spotfire user group inside the "Preferences Tab". Expand "Application" (the 2nd tree from the top) and select "Fiscal Year". Click on the "Edit" button present at the bottom of the window.

A new window will pop up and you can enter the desired value (e.g. -1). Click the "OK" button to apply the setting and close the Spotfire Analyst. For reference, see the attached file (File name: Offset In Months.PNG).

To verify the configuration, open a new instance of the Spotfire Analyst and load data from any .txt/.csv/.excel file and then select Edit menu >> Document properties >> Properties tab. Here you will see the current offset value as shown in the attached image file (File name: Document Properties.PNG).

Reference

https://docs.tibco.com/pub/sfire-analyst/7.9.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/other/other_details_on_document_properties_properties.htm