Build and process budget plan files

A budget includes budget plan files for each department, organized into file groups. Each file group typically contains a single year's budget.

IMPORTANT: Before you build and process plan files, you must first load and reconcile data. For more information, see Loading and reconciling data. Additionally, if you use custom plan file build or plan file process jobs, check your settings against the standard version. Some settings—such as AQ—might have changed.

To create plan files for a new year:

  1. Build plan files - Creates the budget plan file.
  2. Process plan files – Populates the budget plan file with data from the Axiom database that you preloaded.

Budget file groups contain plan files with budget data for each department in the organization. However, you do not copy individual plan files when cloning a file group. Instead, you use the Build & Process Budget Files job in the Axiom Scheduler to generate a new set of plan files for the new budget year.

The system generates budget plan files from templates. The Budget Configuration and Assumptions driver files settings determine which templates are used for a particular department and how those templates are configured.

Within the job, creating and processing are broken out to two different tasks to allow each to be run independent of each other.

Build budget plan files

  1. In the Bud Admin task pane, in the Prepare Budget Plan Files section, double-click Build & Process Budget Plan Files.

  2. In the box on the left side of the Scheduler dialog, click Create Plan Files.

  3. Click the folder icon.

  4. In the Choose File Group dialog, select the file group, and click OK.

  5. To create specific plan files, you can apply filters, as needed. For example, to only run for a selected Entity or Dept. To apply filters, in the Task Details section, click the Plan Files tab. Select the Use filter radio button to access filtering options.

  6. After you select the options you want, in the Job ribbon, click Run Once.

  7. After creating the plan files, you need to process them. For more information, see Process plan files.

Refresh data

Most of the data in Axiom Software is stored in a database. Plan files are typically generated as needed by populating a template file with the relevant data from the database. The template used for a particular plan file often depends on the configuration settings selected in the driver file for that file group. Most plan files automatically refresh/recalculate data on open. If you need to update an open workbook to reflect changes to the database or driver files, however, you can use the Refresh feature.

  • On the Main tab, in the File Options group, click Refresh.

    NOTE: You may be prompted to define values before the refresh occurs. If so, these values are applied to the plan file to impact the data refresh.

View budget plan file templates

Templates define the default file structure for budget plan files. Each template contains one or more sheets that are copied into a budget plan file at the time it is initially created. Individual cells in templates may contain formulas (tags) that define how data flows from the database into the corresponding budget plan file cells and/or how data input or modified in the plan should be written back to the database.

In all Axiom Software products, templates are generally standardized for each application and not editable by users. However, you may still view the contents of templates to help trace formulas back to the source data and understand how data in plan files flows to and from the central database.

Which templates (or sheets within templates) are used to create a particular plan file depends on settings within the related driver files and dimension table(s).

NOTE: After plan files have been created from templates, subsequent changes to the template do not impact the plan files unless the plan files are re-created.

  1. In the ExplorerExplorer task pane, in the File Groups section, click the file group for the templates to view.

  2. Click Templates.
  3. Double-click the template to view.

Process budget plan files

  1. Go to Bud Admin > Prepare Budget Plan Files and double-click Build & Process Budget Plan Files.

  2. Go to Tasks and select Process Plan Files.

    NOTE: The Options tab opens by default. You can select a processing mode or processing and advanced options.

  3. You can apply filters when processing plan files. For example, you want the to only run for a selected Entity or Dept. To apply filters, in the Task Details section, click the Plan Files tab. Select the Use filter radio button to access filtering options.

  4. To process the plan files, click Run Once.