Audience: Administrators who manage the model.
As an administrator, you define the account Type setting. The account Type you choose depends on the kind of data you're tracking: the running balance or the net value per period:
- Periodic: the value is the net for the period.
- Cumulative: the value is the running balance.
- Link (conditional) If you want to learn how to link an account, see Linked Account Overview.
Before You Begin
- Required permissions: Model > Model Management.
- Need general information? See Account Type Setting: Cumulative and Periodic or Accounts Overview.
How You Get There
For General ledger and custom accounts:
From the nav menu, click Modeling. Then, from the Accounts menu, click General Ledger Accounts or Custom Accounts.
For cube and modeled accounts:
From the nav menu, click Modeling. From the Sheets menu, select either Level-Assigned Sheets or User-Assigned Sheets. Click the Edit link next to the cube or modeled sheet. Click the Cube Account link or the Modeled Account link.
Change Account Type Setting
If these accounts roll up to a group, you can edit their account Type settings:
- Custom accounts
- Model and cube calculated accounts
- Cube standard accounts
If the account rolls up to an account, change the type by re-parenting it or by changing the type of its parent account.
- Click an account in the account list to edit the account Type setting.
- If the account rolls up to a group, the account Type setting is editable.
In the following image, Average Daily Payables - Total Company rolls up to Accounts Payable, which is a group. Notice that the account Type setting is editable.
Accounts that roll up to an account have read-only account Type settings. The rollup account's type determines the type of all its child accounts. In the image below the child account has a read-only type.
- If possible, change the account Type.
- Click Save. Any child accounts will automatically change to the same setting.
Rollup Accounts and Re-parenting Accounts
If you re-parent an account, the type of the account will change to match its new parent account.
- You could change Average Daily Payables - Office Expense to roll up to a periodic account. Choose a periodic account from the Rolls up to field. The Type will automatically change. See Reorganize Account Structure.
- You could also select the rollup account, Average Daily Payables -- Total company. Change its type to periodic. This will change all the child accounts too.
Accounts Type Setting that You Can't Change
- Metric and cube metric.
- Assumptions, and cube and modeled assumptions: These accounts are always periodic.
- General ledger accounts. To change the type of a general ledger account, see Reorganize Account Structure.