Skip to main content
Documentatie
Documentatie
Adaptive Planning
Concept: Accounts

Concept: Accounts

Adaptive Planning accounts are containers that group actuals or planning data. Example:
  • Assets.
  • Expenses.
  • Liabilities.
  • Any other business metrics.
Accounts contain mainly raw numbers and formulas. Your team can view account data in:
  • Dashboard charts.
  • Microsoft Excel Interface for Planning.
  • Microsoft OfficeConnect.
  • Sheets.
  • Web reports.
Your team can change account data using:
  • APIs.
  • Integration loaders.
  • Sheets.
  • Spreadsheet imports.
As an administrator, you can:
  • Create new accounts in different account hierarchies.
  • Change account settings to change how accounts work in your model.
  • Organize the structure of the account hierarchies.
  • Import bulk changes to your account structures.
For accounts created by the workforce planning configuration manager, you can't:
  • Change the account Code.
  • Change the account attribute value Name.
  • Change the account attribute value Code.
  • Import account structures if they alter Name and Code mappings.

The Account Hierarchies

These hierarchies are the different account hierarchies in your model:
  • Assumptions.
  • Cube accounts. Each cube sheet has a unique account hierarchy.
  • Custom accounts.
  • General Ledger.
  • Metric accounts.
  • Modeled accounts. Each modeled sheet has a unique account hierarchy.
Your planning model organizes accounts in a hierarchy. There are parent accounts and child accounts that roll up to the parent accounts. Root accounts have no parent. They're the top-level in the hierarchy. Leaf accounts have no child accounts. They're the smallest level in the hierarchy.

Root Accounts

  • You can't delete or create root accounts.
  • Root accounts in the General Ledger act like rollup accounts. They hold the aggregate of their descendant accounts.
  • The root accounts of custom, metric, and assumptions act like account groups. These roots don't hold data. You also can't reference these roots in formulas.

Account Groups

Account groups are folder-like organization tools that contain accounts, without summing totals. Use groups to make it easier to find accounts when you write formulas, build sheets, or design reports and charts. You can create groups for all account types except General Ledger and modeled accounts.

Rollup Accounts

Rollup accounts are parent accounts that sum the total of child accounts. Rollup accounts display values, but can’t store values of their own. General Ledger, custom, assumption, and cube accounts have rollup accounts. Metric and modeled accounts don't.

Rollups with Metric Accounts versus Calculated Accounts

  • Gross margin as a calculated General Ledger or custom account: The formula divides the gross margin by revenue at each level. The rollup accounts total the quotients for each level rollup.
  • Gross margin with a metric account: The gross margin of each level sums at the rollup level. The revenue for each level sums at the rollup level, too. Then, the calculation takes place. The metric formula divides the total gross margin by the total revenue.
Metric Accounts and Dimension Attributes
All the arguments in metric account formulas filter by dimension attribute. You can remove attribute filters if zeros display instead of what you expect.

System Accounts

  • Can exist only in the General Ledger and custom account hierarchies.
  • Can exist on only standard sheets.
  • Hold data that you can't change using sheets or other methods.
  • Are best for allocate-in and allocate-out accounts that you don't manage in sheets.
We don't recommend that you reference system accounts from cube sheets, either in cells or in account formulas. FAQ: What's the best way to reference a system account from a cube sheet?

Account Settings

Account settings affect the behavior, visibility, and data of the account. Depending on the type of account, you can view up to 27 settings. With settings you can:
  • Define the account values as periodic or cumulative.
  • Specify how the data rolls up for totals based on time and other dimensions.
  • Create accounts that use weighted-average translation.
  • Protect data with privacy settings.
  • Link accounts to cube or modeled accounts to preserve dimensionality.
  • Create intercompany accounts.
  • Display actuals data on your plan versions.
  • Create system accounts for allocations.
  • Calculate values with populated formulas. Optionally, add override formulas to specific versions.
You can't change some of the settings of built-in General Ledger accounts.