Defining Account Properties

You define properties for accounts, such as account types, and data types, and whether they are Intercompany accounts.

For Intercompany accounts, see Setting Account Attribute Values.

To define account properties:

  1. Click the Navigator icon Navigator icon.
  2. Under Create and Manage, click Dimensions.
  3. From the Dimension list, select Account.
  4. Select Action, then select Add Child or Add Sibling.
  5. On the Member Properties tab, enter account properties.

Table 11-9 Account Properties

Property Description


Enter a name that is unique across all dimension members.


Optional: Enter a description.

Alias Table

Optional: Select the alias table to store the alias name.


Optional: Enter an alternate name for the member.

Account Type

Select the account type:

  • Expense

  • Revenue

  • Asset

  • Liability

  • Equity

  • Saved Assumption

See Account Types.

Variance Reporting

Select an option:

  • Expense

  • Non-Expense

See Account Types and Variance Reporting.

Time Balance

Specify how the system calculates the value of summary time periods:

See Time Balance Property.

Exchange Rate Type

Indicates the translation options for the financial accounts.
  • Historical

  • Historical Amount Override

  • Historical Rate Override

  • No Rate (for non-historical accounts)

By default, the system uses Average Rate for Flow accounts, and Ending Rate for Balance accounts. The default settings can be changed.

Source Cube

Specify the source cube for the member.

Data Storage

Select data storage options:

  • Store

  • Dynamic Calc

  • Never Share

  • Shared

  • Label Only

See Data Storage Options.

Two Pass Calculation

Select whether to calculate values of members based on values of parent members or other members.

Allow Upper-Level Entity Input

Specify whether parent Entity input is allowed for this account.

When you create a Local Rate account and refresh the database, this attribute is automatically enabled so that you can enter Local Rate data for a base or a Parent entity on the seeded Local Exchange Rate form.

Plan Type

Indicates the application type for which the member is valid.

Data Type

Select a data type:

  • Unspecified

  • Currency

  • NonCurrency

  • Percentage

  • Date

  • Text

  • Smart Lists

See Data Types and Exchange Rate Types.

Smart Lists

Optional: Select a Smart List to associate with the member.

Enable for Dynamic Children


Number of Possible Dynamic Children


Access Granted to Member Creator

Inherit—The member creator will inherit the closest parent's access to the newly-created member.