About Management Ledger Dimensions

Oracle Hyperion Profitability and Cost Management uses dimensions and members created in Oracle Essbase and Profitability Application Manager to represent many of the structural elements of the business model.

A dimension type is a dimension property that enables the use of predefined functionality. The specific characteristics of the dimension type manage the behavior and functions of the dimension. Because Profitability and Cost Management and other Oracle Hyperion Enterprise Performance Management Workspace products may share certain dimension types, you can leverage the functionality of dimensions for different products.

See these sections for important information about Profitability and Cost Management dimensions that are common to all application types:

• About Profitability and Cost Management Dimensions

• Dimension Types

  • Profitability and Cost Management Business Dimensions

  • Profitability and Cost Management POV Dimensions

  • Profitability and Cost Management Attribute Dimensions

  • Profitability and Cost Management Alias Dimensions

Management Ledger System Dimensions describes system dimensions that are specific to Management Ledger applications and models:

Management Ledger Dimension Requirements

The database outline provides the data structure for the model, and includes calculation instructions and formulas. Dimensions in the Essbase outline are hierarchical. Data is stored at dimension intersections The following are Management Ledger Profitability dimension requirements:

• Applications or models must contain at least one POV dimension and can have up to four POV dimensions.

• Applications must contain one and only one system dimension named Rule.

  Users can edit and add more members to the Rule dimension For example, R1001 thrugh R1500. Optionally, they can also trim that dimension. The Calculation Programs member in the Rule dimension is not editable.

• Applications must contain one and only one system dimension named Balance.

  System dimension members in the Balance dimension cannot be edited. Users can, however, add alternate hierarchies.

• There should be at least one business dimension with no duplicate members.

  Caution:

  Members must not be repeated within the same dimension. However, members can be repeated across several dimensions.

Figure 8-1 shows a sample Essbase outline of a Management Ledger Profitability database, shown on the Essbase console.

Figure 8-1 Essbase Outline of a Management Ledger Profitability Database