The Account dimension represents a hierarchy of natural accounts. Accounts store financial data for entities and scenarios in an application. Each account has a type, such as Revenue or Expense, that defines its accounting behavior. The Account dimension is mapped from the source accounting entity to the EPM Account dimension as defined in the dimension mapping definition for the selected chart of accounts or business unit. The properties set by ERP Integrator are shown in the following table. (Any properties not set are defaulted by either the application or Performance Management Architect.)
| Property | Application Type | Population Method / Value |
|---|---|---|
| Consolidation Account Type | Consolidation | Populated from the account type in the source accounting entity with the domain of revenue, expense, asset, or liability. If source type is equity, it is changed to liability for use by Financial Management applications. |
| Account Type | Planning | Populated from the account type in the source accounting entity with the domain of revenue, expense, asset, liability or equity. |
| Variance Reporting | Planning, Essbase ASO, and Essbase BSO | Set to “Expense” if account type is expense, otherwise set to “NonExpense.” (NonExpense is the default.) |
| Description, Display String | System | Populate from source accounting entity description. |
| Time Balance | Planning, Essbase ASO, Essbase BSO | For income statement accounts, (revenue and expenses) set to “Flow” for Planning applications. For Essbase ASO and BSO applications, set to “Last.” For balance sheet accounts (asset, liability, and equity), set to “Balance.” These properties can be set when you create metadata rules. See Defining Metadata Rules. |