About Standard Profitability Dimensions and Metadata

Dimensions and metadata are created and maintained by the Oracle Hyperion Profitability and Cost Management Administrator, using the Profitability Applications Console.

By using common dimensions and members, Profitability and Cost Management can easily use and transfer common data with other products, such as Oracle Hyperion Planning, saving time and effort, and improving accuracy. For detailed information on creating and maintaining dimensions and metadata, see Creating Applications Using the Profitability Applications Console.

Profitability and Cost Management uses the dimensions and members created in the Profitability Applications Console to represent many of the structural elements of the business model:

  • AllocationType dimension that stores both direct allocations and allocation genealogy data

  • Dimensions that provide the structure for the model and scenarios, such as the Source and Destination Measures dimensions.

  • Business dimensions that reflect the business-specific elements of the model, such as departments, General Ledger accounts, activities, customers, or products

  • Point Of View (POV) dimensions, such as time periods, scenarios and versions

  • Alias dimensions, as required

  • Attribute dimensions, as required

For each dimension, both a dimension type and dimension name must be specified:

  • Dimension type is a dimension property that enables the use of predefined functionality for selected dimensions. See Dimension Types.

  • Dimension name is assigned to identify the contents of the dimension, in relation to your organization or business. For example, a dimension of Account type may be given a dimension name, such as General Ledger or Chart of Accounts. The dimension name does not need to reflect the dimension type, although it may. For naming restrictions, see Essbase Naming Conventions.

Caution:

Although there is no physical limit to the number of dimensions and members that can be created, performance issues occur with large dimensional structures.

The sort order for dimensions in a Profitability and Cost Management model must be set in a certain sequence, to maximize processing and calculation. See Setting the Dimension Sort Order.

For detailed instructions on creating and maintaining the dimensions and members, see Creating Applications Using the Profitability Applications Console. For naming conventions for dimensions and members, see the Essbase Naming Conventions.

See these sections for information about the Profitability and Cost Management dimensions: