iMIS analytics is shipped with the fiscal year set to the calendar year by default. This would be the same as having 0 or 1 in the AR/Cash setup for fiscal year.

To change the fiscal year for the transaction data for Analytics, the parameter just needs to be changed.

1) With the ‘Analytics Configuration’, set “ETL.FiscalYearBegins” to the first month of the fiscal year (1 to 12) and save. See Changing Analytics Configuration Options for instructions.

2) From a SQL browser, select the Analytics data warehouse as your current database and run the following procedures:

a. EXEC asi_DWSInitDB
b. EXEC asi_DWSETLAll 1

3) Rebuild the cubes