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 Intercompany 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 10-1 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

Variance Reporting

Select an option:

  • Expense

  • Non-Expense

Time Balance

Specify how the system calculates the value of summary time periods for Revenue and Expense accounts.

Select the option from the following:.

  • Flow to calculate using the Average Rate
  • Balance to calculate using the Ending Rate


Select an option:

  • None

  • Missing

  • Zero

  • Missing and Zero

Exchange Rate Type

Indicates the exchange rate for the account.
  • Historical

  • Historical Amount Override

  • Historical Rate Override

  • No Rate (for non-historical accounts)


The system always uses Average rate for Flow accounts, and Ending rate for Balance accounts.

Source Cube

Specify the source cube for the member.

Data Storage

Select data storage options:

  • Store

  • Dynamic Calc and Store

  • Dynamic Calc

  • Never Share

  • Shared

  • Label Only

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.

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

Smart Lists

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

Enable for Dynamic Children

Enables users to create children for this member by entering a member name in the runtime prompt for a business rule that has been configured with a dynamic parent member).

Number of Possible Dynamic Children

This option is available if Enable for Dynamic Children is selected. Enter the maximum number of dynamically-added members that users can create. The default is 10.

Access Granted to Member Creator

This option is available if Enable for Dynamic Children is selected. Determines the access that member creators have to dynamic members that they create with a runtime prompt:
  • Inherit—The member creator will inherit the closest parent's access to the newly-created member.

  • None—The member creator will not be assigned any access to the newly-created member. (An administrator can later assign the member creator access to the members.)

  • Read—The member creator will be assigned Read access to the newly-created member.

  • Write—The member creator will be assigned Write access to the newly-created member.


If an administrator changes these settings, they affect only future dynamic members; they do not retroactively affect dynamic members.