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 FDMEE are shown below. (Any properties not set are defaulted by 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 aggregate storage, and Essbase block storage | 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 aggregate storage, Essbase block storage | For income statement accounts, (revenue and expenses) set to “Flow” for Planning applications. For Essbase aggregate storage and block storage 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. |