E.2 How YTD Calculations are affected by a Fiscal Year Configuration

The Management Ledger table contains each of your Key Processing dimensions, several administrative columns that are also components of the table's primary key, and two “fact” columns (balance columns).

When you are running a standard calendar year configuration, the records with FISCAL_MONTH equals to 1 corresponds to January data and FISCAL_MONTH equals to 12 corresponds to December data. If, however, your Start-Month column was set to 9 (indicating that your fiscal year begins in September), then the records with FISCAL_MONTH equals to 1 would correspond to September, and records with FISCAL_MONTH equals to 12 would correspond to August.

Year-to-date calculations begin at the start date of the fiscal period rather than January of the year in which the calculations are performed.

This is an important consideration for the following calculations:

• Allocation rules that insert into or update the table.
• The allocation UNDO process that performs updates or deletes.
• Table-to-Table load into the Management Ledger table.
• Transfer pricing rate migration from instrument tables to the table through OFSAA Funds Transfer Pricing.
• Direct transfer pricing of the table through OFSAA Funds Transfer Pricing.