About properties for the Account dimension

The following table describes the predefined properties of Account dimension members.

Property

Description

AccountTypeMemberID

A selectable option that groups the account member into a type, such as Tax Expense or Liability, for use with business rules. Planning Business Modeler uses this property to determine the aggregation behavior for accounts.

NoteNote:

When using this property in a business rule calculation, you must explicitly reference the property as AccountTypeMemberID. Do not use a substitute such as "Account type".

Account types are grouped into the following account classifications*,* according to the type of report that uses the account type:

DebitCredit

Indicates whether, for calculation purposes such as aggregation, Planning Business Modeler treats this account type as a debit entry or a credit entry. When used in calculation, an account type that has a debit name has a negative sign for calculation, and an account type that has a credit entry has a positive sign.

TimeBalance

Indicates how Planning Business Modeler handles values in this account type for aggregation. The following values are possible:

  • Sum — aggregation value is the sum of all child members.

  • End — aggregation value is the last nonempty child along the Time dimension. Also called Last-child aggregation.

  • Avg — aggregation value is the average value of member children.

Consolidated

Boolean (TRUE-FALSE) value that indicates whether this account type should be included in the Planning Business Modeler consolidation calculations.

Converted

Boolean (TRUE-FALSE) value that indicates whether this account type should be included in the Planning Business Modeler currency conversion calculations.

Intercompany

Boolean (TRUE-FALSE) value that indicates whether this account should be included in intercompany calculations.

Account type property values cannot be changed separately. To change property values, you must change the type of the account.

See Also

Other Resources

About the Account dimension