Contains preview content for the 2020R2 release.
Audience: Administrators who manage the model.
A custom account is an account that can hold any kind of numerical data or formulas. The rollup logic for time, dimension, and level is flexible as are many of the settings that create accounts with unique capabilities.
To learn more about accounts, see the Accounts guide. For step-by-step instructions, see Add or Edit Accounts.
Account Details Section
Required. No default.
Identifies a unique numerical code for the account. Appears in formulas. Enter a unique combination of letters and numbers. You can use underscores but not spaces or other special characters. If left blank for imports, the code is auto-generated.
Required. No default.
Identifies the name of the account as it to appears on sheets, reports, and charts. Enter any combination of characters, spaces, and special characters. The account name does not need to be unique.
Optional. No default.
Identifies the name of the account as it appears on dashboard charts. Use if the account name is long. Enter any combination of letters, numbers, and special characters.
|Rolls up to||
Required. Default: the account or group that's highlighted when you select Create New Account.
Optional. No default.
Describes the account. Enter any combination of letters, numbers, special characters and spaces.
Required. Defaults: the same type as the rollup account, or periodic if the account rolls up directly to either the Custom root or a group.
Sets how the account data entries relate to other data entries. If you change a rollup account type, you automatically change its child accounts too.
For new accounts choose:
Required if you selected Link for the Type of the account you're editing. Not available for rollup accounts. No default.
Populates the account you're editing with the data of the account you choose from the drop-down. This is a two part process: first pick your cube or modeled sheet, then the account. See Pull Data from from a Modeled or Cube Sheet into Another Account.
Optional. Available only if you selected Link for Type. Not available for rollup accounts. No default.
Populates this account only with the values that are tagged with the dimension or attribute you select from the drop-down. The available list includes only dimensions and attributes of the account selected in Links to drop-down.
Required. Read-only if you select Link for Type or Cube for Data Entry Sheet Type. Defaults: the Time Rollup of its rollup account or linked account. If it rolls up to a root or group, the default is Sum of rolled up values for periodic accounts and Value of last time period for cumulative accounts.
Sets how the account calculates the values for time rollups. For example, how does the account calculate the quarter totals or annual totals? If editable, choose from the drop-down:
Optional. Read-only for child accounts, or if you chose Link for Type, or Cube for Data Entry Type. Default: Sum of rolled up values for new accounts or the Dimension Rollup of the parent account or linked account.
Sets how the account calculates the totals for level and dimension rollups. For example, Total Company is a level that has three departments as sub-levels: Sales, Manufacturing, and IT. You enter 100, 200, and 0 for each level respectively. At the top-level, choose how you would like Total Company to display the rollup value:
Required if you chose Weighted average of roll up values for Time Rollup or Dimension Rollup. No default.
Provides the weighted average of the time or dimension rollup. Choose from the list of accounts.
Optional. Available if you chose Text for Dimension Rollup. No default.
Provides the text that displays for dimension rollups. Enter any kind of text, such as NA or --, or leave blank.
Required when visible. Available for cumulative accounts only. Not available for rollup accounts. Default: the setting of the rollup account.
Sets how you enter data for the account you're editing in the sheet cells of planning versions. For example, the initial petty cash balance for the account is in January and the value is 10. In February the value is 20. In March the value is 20. Choose:
Sets how you enter data for the account you're editing in the sheet cells of actuals versions.
For example, the initial petty cash balance for the account is in January and the value is 10. In February the value is 20. In March the value is 20. Choose:
Required. Not available for rollup accounts or accounts that have Cube selected for Data Entry Sheet Type.
Determines if the account displays actuals data on planning versions prior to the Start of Plan date. See Set Up or Turn Off Actuals Overlay.
For cumulative or periodic accounts, choose:
For Link accounts, choose:
Specify Default Formulas link:
Optional. Not available for rollup accounts. Only available if you chose Enable actuals for Actuals Overlay. No default.
Assigns shared formulaa to the account for each level in actuals versions. On sheets, you can override the values calculated by the shared formula with formulas or data entered in the sheet.
Select the Specify Default Formulas link to access and assign shared formulas of your actuals by level. If you don't have access to actuals, you can link to the shared formulas of your planning version.
Optional. Not available for rollup accounts. No default.
Assigns shared formulas to the account for each level of your planning versions. On sheets, you can override the values calculated by the shared formula with formulas or data entered in the sheet .
Select Set Default Values and Formulas to access the shared formulas of your planning versions. Assign formulas to each level. See Formulas for more information.
Shows how the account is used throughout the model in calculated accounts, shared formulas, cube entries, other entries, rules, journal entries and reports. Select View Dependencies and browse through the tabs.
Account Attributes Section
Optional. Only available if your model has account attributes. No default.
Tags the account you're editing with account attributes. The number of drop-downs match the number of account attributes available. Select an attribute value from any or each of the drop-downs.
Data Type Section
Account Time Stratum
Shows how sheets display time for this account. Based on the default time stratum in your instance's calendar setup. Most commonly, this is month
Required. Read-only for child accounts or accounts with Link for Type. Default: Number or whatever was chosen for the rollup account.
Sets how data appear in sheets and on reports. Choose:
|Formula Version Selector||
Lets you view or create override formulas for the version you select. Read-only until you select the Override checkbox. See Edit Account Formulas and Override Formulas
Unlocks the Formula Version Selector so you can view, edit, or create override formulas for a version. Read-only if you select a locked version. See Edit Account Formulas and Override Formulas.
Required if you select the Weighted-Average Translation check box. Not available for rollup accounts or if you chose Cube for Data Entry Sheet Type. No default.
Calculates the value of the account you're editing through a formula. Unlike default formulas, master formulas calculate the value across all levels and all versions. A master formula overrides any shared formulas and all data. To edit the data of accounts with a master formula, you must edit the master formula or create an override for a version. See Edit Account Formulas and Override Formulas.
Read-only if you select a locked version from the Formula Version Selector.
Optional. Not available for rollup accounts or periodic accounts. Cumulative accounts must have Delta chosen for Plan by and Actuals by. No default.
Converts currencies by the average rate per period on the delta of cumulative accounts. Generally references a periodic account in the master formula and provides a way to convert the currency of periodic data in cumulative accounts.
Requires Weighted Average Translation.
Resets the balance to zero at the specified time period. At the start of the next period, the account starts accumulating again. Choose the time period. Available options are based on the calendar setup of your model, typically Month, Quarter, Year.
|Transfer Balance on Reset||
Requires Reset Balance.
Transfers the accumulated balance to another account. Choose the account to receive the balance transfer.
Required. Default: 0.
Indicates the number of decimal places for the data. Select any number between 0-9 or choose Currency's precision to follow the setting for the currency.
To see the decimal place settings for all the currencies, choose Currency's precision from the drop-down and select the View Precision link.
Required. Default: the exchange rate selected for the rollup or root account.
Determines how to convert currencies for the account. Choose:
|Suppress on sheets||
Required. Default: Account may be suppressed when zero or blank.
Determines if the account appears on sheets if all its cells have zeros and/or blanks. Choose:
Required. Only available for rollup and root accounts.
Determines if the account is expanded on sheets to show child accounts when you first open the sheet.
Each person who opens a sheet can change their sheet view and save it as their default, which can override this setting. Choose:
|Data Entry Sheet Type||
Required. Not available if you chose Link for Type or for standard cube accounts. Default: Standard or the sheet type selected for the parent account or group.
Specifies the type of sheets you can add the account to when building sheets. Choose:
|Entered on Sheet||
Read-only. Available if you chose Cube for Data Entry Sheet Type.
Displays the name of the cube sheet that has this account. Displays None until you add the account to the cube sheet. Select the sheet name to link to edit the cube sheet.
|Read only on sheet||
Available for cube standard accounts only.
Makes the account uneditable on the cube sheet.
Data Privacy Section
Restricts how formulas can use the account's data by level. Choose:
|Contains Salary Detail||
Required. Not available if you chose Cube for Data Entry Sheet Type. Read-only if you chose Link for Type. Default: the same as the rollup or linked account.
Indicates if this account is restricted to only user roles with the Salary Detail permission. See Available Permissions. Choose: