Template Line Types

Template Line Types

When you design a template, there are several line types you can apply; H, L, C, RC, RA, DA, and N. Each of these lines types is described below.

L
Indicates there are sublines. Subline details allow budget end-users to itemize any account on the template input page accessed from the Planning Control Panel.

C
The row is designated as Calculated and you can add calculations and formulas.

Formulas are typically used in templates to calculate items and look up values. A table with commonly used template formulas is provides below.

H
Indicates the line is a header line. These lines are not editable for end-users. You might use this line type to enter notes for end-users or to format the template and even to add additional spacing.

N
Indicates notes are attached to the line. Notes might provide additional detail on the line or instructions to the end-user.

RA
RA stands for Reference Account and indicates another account is referenced for that template line. For example, you might have a payroll account referenced from an Workforce template line.

By default, blank cells are displayed for zero value Reference Account lines. If you want to display a dash versus the blank cell, change the MDX. An example is provided below.

Example 1:

If this is the original MDX:

[Account].&[1]

Then this is how you would add the dash:

iif([Account].&[1]=0,0,[Account].&[1])

Example 2:

If this is the original MDX:

IIF([Account].&[100]=0,0,[Account].&[100])

Then this is how you would add the dash:

IF(Sum({[Account].&[100],[Account].&[101]})=0,0,Sum({[Account].&[100],[Account].&[101]}))

DA
DA stands for Destination Account and indicates that template line is mapped to a segment combination. Destination accounts are used to save budget or forecast data entered or calculated in a selected budget template against a General Ledger account.

RC
RC stands for Reference Cube and indicates the line references data from the reporting cube. For example, the line displays a total from data that was looked up. The results is total revenue for all sales departments in a legal entity.

See Reference Cube for information on why and why to use this type of line in a template