Understanding the Template Setup Application Page

Understanding the Template Setup Application Page

Mappings

Account Mapping

Maps template lines to segment members. Select one of the following options:

• Destination Account (DA) - select a line in the template and open the Destination Account page to map template rows to segment combinations. Destination accounts are used for saving the budget or forecast data entered or calculated in a selected budget template against a General Ledger account.

  On the Destination Account Mapping page:

  1. To perform a Mass Destination Account Mapping, select All from the Lines list box. This selection displays all template lines and enables Mass Mapping.
  2. Select segment members for each line and click Save.

• Reference Account (RA) - select a line and open the Reference Account page to enable the look up of data from another template. For example, payroll accounts may be looked up from the Workforce template.

  On the Reference Account Mapping page:

  1. To perform a Mass Reference Account Mapping , select All from the Lines list box. This selection displays all template lines and enables Mass Mapping.
  2. Select segment members for each line and click Save.
• Reference Cube (RC) - select a line and 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. Or, pull revenue data into a planning template as a basis for cost allocations.
• Mass Load - this option mass loads multiple account members at once and inserts rows for each. . On the Mass Load page, select the checkbox to select or deselect all accounts to load.

checkbox to select or deselect all accounts to load.

Using this Bulk Add option, you can select all the applicable dimensions at the Rollup and the Leaf level, and add the multiple template line items in one go.

1. To perform Bulk Add, go to Mappings and select Bulk Add. On the Bulk Add screen, select the required members you wish to add from all the respective tabs. 
2. Click Save.

For segment hierarchies exceeding 10,000 members, the hierarchy is displayed progressively, i.e. the root and its immediate children (up to a maximum of 5,000 members) are shown initially. You will need to expand the rollups to view and select the rollups/leaves at further levels. The limit of 5,000 members applies to the expansion of rollups at any level in the hierarchy. You need to use the search option to view and select segment members beyond this limit. 

For smaller hierarchies containing 10,000 or fewer members, the entire hierarchy will be visible by default. This means you can quickly navigate the hierarchy and select required rollups/leaves.

Template Mappings

Entity Mapping - open the Entity Mapping page to map entities to the template.

Approval Role - open the Approval Role page where you can set approval actions.

Global Field Mapping - open the Map Global Fields page to map global fields to the template.

Methods

Monthly Increase $ - Select this option to apply a dollar amount increase over the history for each monthly period.
Monthly Increase % - Select this option to apply an increase percent based on the history amounts for each month.
Full Year Growth - Select this option to apply a total increase percent based on history, and use a spread method to distribute the amounts to the monthly periods.
Annual Value - Select this option to apply a total dollar amount based on history, and use a spread method to distribute the amounts to the monthly periods.
Spreads - Spreads allow users to spread annual value to period columns based on a selected spread method. Select an option (i.e. evenly, 4-4-5, etc.) to apply the spread to the template row that can be modified by the user. Spreads are optional. You may opt to spread based on history data (History Scenario).

Global Fields - Apply a global field to a template row, which displays the lookup formula in the template setup. Global Fields that populate this list box are defined on the Global Fields page. Global Fields are optional.

Round - Round numbers off to the nearest whole number. For example; 67.7 will appear as 68.

More

Account Reports

Destination Account Report - open the Report page to view each line that is identified as a destination account and print or download the report in Excel format.
Reference Account Report - open the Report page where each line that is identified as a reference account is displayed. Print or download the report in Excel format.
Show Rule - open the Rule page to view associated multi-dimensional expressions.

Header

Notes - View all notes for the related scenario.
Snapshot - Take a snapshot of the template. Snapshots may be stored in the File Cabinet.
Template History - View information on when the template was modified and by whom.

Grid Actions

Select from the following actions:

Show/Hide Formula Bar - Display or hide the Excel formula bar.

Hide/Show Format Bar - Display or hide the format area, which is where you insert lines, borders, format numbers, and more.

Show/Hide Row Header - Hide or display the template row numbers.

Show/Hide Column Header - Hide or display the template column letters.

Show/Hide Tabs - Hide the tabs for Global Fields and Spreads that appear at the bottom of the Template Input and View screens.

Show/Hide Scenario Header - Display or hide column header information. Column scenario headers display scenario name. Admin users can choose to set the display globally (to hide or show) for column headers. If an Admin user hides the display of column headers globally, other users will not be able to see this information.

Show/Hide Column - Hide or show selected columns (within any template except Initiative templates) to improve visibility.

Reset Column Width - Reset the column width based on the template setup your Admin user performed.

Show/Hide Data Filter - Filter Spreadsheet Data similar to Excel as shown below.

Data filter functionality is available for the following template types: Allocation, Block, Sales, Global Template - Single Copy, Global Template - Entity Copy, Line Item, and HR.

Reset Column Width Globally - Set columns widths to a default width. This option is available for Global Template Single Copy, Global Template Entity Copy, and Allocation template types. Selecting this option will reset column width preferences of all template users for a specific scenario irrespective of the budget entities. This option is available for templates that are not associated with the Default scenario only

Freeze/UnFreeze Grid - Select Freeze to keep an area of the worksheet visible while you scroll to another area. UnFreeze disables this ability. Freeze panes are user-specific. For example, Jane Doe can set her freeze panes for the BudgetQ12019 template (from the Planning Control Panel - Template Input page) and John Doe can set his freeze panes as desired for the same template. Even if Jane and John have different freeze pane settings, the template will display accordingly based on their selections.

Hide/Show Attributes - Display or show the Attributes column.

Seeding Report

Exception Report - Export a detailed report to view information about the values in the source scenario and the replaced value and formula in the target scenario, when the formulas could not be transposed during seeding. This report contains details such as Scenario, Entity, Template, Column and Period references, Source Value, Destination Formula, and Destination Value.

Format Bar

Insert and remove template lines. Select one of the following row types for each line within the template:

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

• HEADER (H) - Format sections or provide additional spacing within a template or add instructions for end users.

• 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.
  Apply bold, italic, text color, background color, and borders.
  Format:

  • Text - Select to allow the entry of text.

  • Number - Select to allow numerical entries.

  • Currency - Select to allow the system to enter a currency symbol ($) for all numerical data entered.

  • Percent- Select to allow the system to place a percent symbol (%) behind all numerical data entered.

• Hidden - Select to show or hide the column from users.