Unsupported content This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Repopulating the fiscal calendar table

Occasionally, you might update database objects and want to repopulate the fiscal calendar table.

To repopulate the ANA_FISCAL_CALENDAR table

(For MSSQL) Execute the following command at the SQL prompt to execute the program:

SQL>EXECUTE Populate_Fiscal_Calendar <CalendarStartYear>,<NumberOfYears>,<CalendarStartMonth>;

(For Oracle) Execute the following command at the SQL prompt to execute the program:

EXECUTE Populate_Fiscal_Calendar (<CalendarStartYear>,<NumberOfYears>,<CalendarStartMonth>)

Enter values for each of the following parameters:

  • <CalendarStartYear> — The value of the year that you want to be the start year of the fiscal calendar. You must enter a value from 1970 to 2037.
  • <NumberOfYears> — A value that represents the duration of the fiscal calendar. For example, if you entered 2009 as a start year and you want the fiscal calendar to end 2 years from the start time, you would enter a value of 2.
  • <CalendarStartMonth> — The month that you want to be the start month of the fiscal calendar, where the number 1 represents January, 2 represents February, and so on. If you entered 5 for May, the first date appearing on the report is May 1st.
Example

If you wanted the fiscal calendar to run from April 2009 through March 2012, you would enter the following command:

  • For MSSQL—SQL>EXECUTE Populate_Fiscal_Calendar 2009,3,4;
  • For Oracle—EXECUTE Populate_Fiscal_Calendar (2009,03,04)

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*