Summarize data

For purposes of rolling forecasting, you need to summarize GL General Ledgerand statistics data. Summarizing data is necessary before you can build plan files and create forecasts. If your system is integrated with Axiom Budget Planning, you can also use the Summarize Budget Data utility for importing budgeting data.

You can also filter your summarized imports by RFGroup if you do not want to import all files.

Use the Summarize Actual Data utility to map department and account-level data to higher-level groups using summary codes called RFCode (for accounts), RFGroup (for departments), and RFID (for initiatives). These codes and groups are summarized in the Axiom Rolling Forecasting data table named RF_Forecast_[year]. From there, these codes and groups are assigned to months/quarters during plan file creation.

NOTE: Only Axiom Rolling Forecasting administrators and analysts can run these utilities.

To run the Summarize Actual Data utility:

1. To use data in more than one place in the system, or to use data in a different location, map the data use exceptions using the RFSummarizationMap utility before running the summarizing data utility.
2. In the RF Admin task pane under Data Transformation, double-click Summarize Actual Data.
3. In the Execute Import: Summarize Actual Data dialog, click Execute.
4. In the Variables dialog, select the year of actuals data to import, then select whether to include statistical data, and then select hours. Click OK.