Actual Data Template Setup

How to Design an Actual Data Template

Once you've added an Actual Data template, design the template using Template Setup. Click the Template Setup button from the Actual Data page as shown below.

To design the template with a structure (data lines), you have several options:

• Insert line types. L lines allow data entry or calculations to be performed for the row. Reference and destination accounts may be applied to a line. Change the line type to a Header (H) or Calculated (C) line. C lines allow calculations to be defined for a row within the template design, preventing budget users from modifying the formula. Destination accounts may be applied to a calc line. H lines allow you to format sections or provide additional spacing.

• Populate the template line by mapping them to segment combinations. Select Mappings, Destination Account. Destination accounts are used for saving the budget or forecast data entered or calculated in a selected budget template against a General Ledger account. These lines display with a DA.

• Populate the template line by referencing an account from another template. Select Mappings, Reference Account to look up of data from another template. For example, payroll accounts may be looked up from the HR template. These lines display with an RA.

• Select Mappings, Reference Cube to open the Rule page to look up data from the cube. For example, you can look up total revenue for all sales departments within a legal entity. These lines display with an RC.

• Mass load data by selecting Mappings, Mass Load. The Mass Load page is enabled where you can select members to load based on dimension member parameters you select. These lines are also labeled with an L.

• Set the format for the template; number, currency or percent.

• Add borders, text colors and background color.

Actual Data Through Template Setup Examples

Cash Flow

Days to Close Books

Parent Interest Ownership Percent

Allocations

Description of Fields

Select mapping options and design the layout or structure of the template.

Adjust column widths by dragging the lines (similar to an Excel spreadsheet). Once saved, the column widths are saved to the template. Column widths are not user specific.

Mappings

Map template rows to segments. Select one of the following options:

• Destination Account - map template rows to segment combinations.

• Reference Account - look up of data from another template. For example, payroll accounts may be looked up from the HR template.

• Reference Cube - look up data from the cube. For example, you can look up total revenue for all sales departments within a Legal entity.

• Mass Load - Insert rows and configure the account mapping within the template.

More

Account Reports

• Destination Report - open a dialog page to view each line that is identified as a destination account and print or download the report in Excel format.

• Reference Report - open a dialog page where each line that is identified as a reference account is displayed. You may print or download the report in Excel format.

• Show Rule - open the Rule dialog page to view associated multi-dimensional expressions.

Ribbon

Line Type List Box

Set the line type of each line in the template by selecting the appropriate type. Select from the following options:

• LINE (L) - Allow data entry or calculations to be performed for the row. Reference and destination accounts may be applied to a line.

• CALC (C) - Allow calculations to be defined for a row within the template design, preventing budget users from modifying the formula. Destination accounts may be applied to a calc line.

• HEADER (H) - Format sections or provide additional spacing within a template.

Format

Apply number, currency, or percent formatting to rows.

Decimals

Apply up to 6 decimals per row.

FX

• Summary information for the cell.

• Calculation associated with the cell.

• Result of the equation or calculation associated with the cell.