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.