Reference: Settings for Cube Standard Accounts

Account Details

Field	Description
Code
Name
Short Name
Rolls up to
Type	Cumulative : The value accumulates period to period. Periodic : The value in any given time period equals the net activity for that period. Link (unavailable for rollup accounts): The value in modeled or cube accounts populate the values of this account. See Concept: Type Setting for Accounts and Concept: Linked Accounts.
Planned by
Actuals by
Links to
Add Linked Accounts or Edit Linked Accounts
Change Sign +/-
Apply Dimension Value
Link Filter
Time Rollup	Sum of rolled up values (periodic accounts only): Sums all the values for the period. Example: Sums January through March for the first quarter rollup. Value in last time period (cumulative accounts only): Takes the value of the last period before the rollup. Example: Takes the accumulated value for March for the first quarter rollup. Average of rolled up values : Takes the average of the time period values. Example: Totals the values for January through March and then divides by 3 for the first quarter rollup. Weighted average of roll up values : Uses the values of an account or assumption to weigh each period before averaging. Example: An average expense per headcount time rollup weighted by the headcount. Linked accounts inherit the time rollup of the source account.
Level/Dimension Rollup	Linked accounts inherit the level and dimension rollup of the source account.
Weighted By
Display Text	Required when Level/Dimension rollup is Text .
Enable actuals
No actuals for account
Enable actuals for link
Show actuals if linked accounts has them
Dependencies

Account Attributes

Field	Description
Prompts with the account attributes available in your model. Varies per instance.

Data Type

Field	Description
Account Time Stratum
Display As	Currency : Converts to the currency of the level. Select when your model converts currencies at different levels. Otherwise, the rollups of the account display the total of the first child account instead of the total of all child accounts. Number : Displays a numerical value. Percent : Displays a percent.
Decimal Places
Exchange Rate

Sheets

Field	Description
Account may be suppressed when zero or blank
Account will not be suppressed even when zero or blank
Start expanded	Available for rollup accounts.
Read only on sheet	Locks the account on the cube sheet.

Data Privacy

Field	Description
Value of account is private
Value of account is public at top level only
Value of account is public at all levels