Account

In addition to the properties described in the table, Account dimension members use most of the common properties described in Properties Applicable to All Planning Dimensions, such as:

  • Valid for Plan

  • Two Pass Calculation

  • Aggregation

  • UDA

  • Member Formula

  • Alias

  • Data Storage

  • Smart List

  • Data Type

Accounts specify information needed from budget planners. You can define calculations in the account structure. Account dimensions must have an association with Attribute and Alias dimensions in order to assign attribute values and aliases to members of the dimension. If accounts are valid for multiple plan types, specify the source plan type to determine which database stores the account value. For accounts with Dynamic Calc or Dynamic Calc and Store properties, you can use Two Pass Calculation to recalculate data values of members that are based on data values of the parent member or other members.

Property Label

Description

Property Name

Time Balance

Set the method for calculating the value of summary time periods: None, Flow, First, Balance, Average, Fill, Weighted Average - Actual Actual, Weighted Average - Actual 365, Last.

Default Value: N/A

 TimeBalance

Skip Value

If the time balance property is First, Balance, or Average, specify how database calculations treat zeros and missing values when calculating parent values:

  • None: Zeros and #MISSING values are considered

  • Missing: Excludes #MISSING values

  • Zeroes: Excludes zero values

  • Missing and Zeroes: Excludes #MISSING and zero values

When you define the value for this property at the parent level, all descendants automatically inherit the value. If the value is overridden for a descendant member of the original parent, its own descendants inherit the new value.

Default Value: None

 SkipValue

Expense Reporting

Set whether the account is treated as an expense for variance reporting:

  • Expense: Actual value is subtracted from budgeted value

  • Non Expense: Budgeted value is subtracted from actual value

When you define the value for this property at the parent level, all descendants automatically inherit the value. If the value is overridden for a descendant member of the original parent, its own descendants inherit the new value.

Default Value: Non-Expense

 VarianceReporting

Account Type

Define account time balance (how values flow over time) and sign behavior for variance reporting: Expense, Revenue, Asset, Liability, Equity, and Saved Assumption.

When you define the value for this property at the parent level, all descendants automatically inherit the value. If the value is overridden for a descendant member of the original parent, its own descendants inherit the new value.

Default Value: Revenue if a new member is created at root level. Otherwise it inherits the value from the parent.

 AccountType

Exchange Rate Type

Set how numeric values are stored in Account members and used to calculate values. This setting determines which exchange rate is used during calculations to calculate reporting currency values. For accounts with Currency data type, these options are valid for any time period:

  • None

  • Average: Average exchange rate

  • Ending: Ending exchange rate

  • Historical: Exchange rate in effect at some point

For accounts, if Data Type is set to any value except Currency, Exchange Rate Type must be set to None.

When you define the value for this property at the parent level, all descendants automatically inherit the value. If the value is overridden for a descendant member of the original parent, its own descendants inherit the new value.

Default Value: Average (or None if Data Type is not set to Currency)

 ExchangeRateType

Source Plan Type

If an account is used in multiple plan types, the plan type database that stores the account value. When an Account member is moved, valid plan types are determined by what is common to the member and its new parents. If the new parent has a different source plan type, the source plan type of the member is set to the first new valid plan type of that member.

When you define the value for this property at the parent level, all descendants automatically inherit the value. If the value is overridden for a descendant member of the original parent, its own descendants inherit the new value. If the new parent of an Account member has another source plan type, the source plan type is set to the first new valid plan type of that member.

Default Value: Plan1

 SourcePlanType