Account
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 Oracle Hyperion Financial Data Quality Management, Enterprise Edition are shown below. (Any properties not set are defaulted by the application or Oracle Hyperion EPM Architect).
Table 1-3 Account Dimension Required Properties
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 Oracle Hyperion 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 the 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. |