1. User's Guide
  2. Working with Detailed Profitability
  3. Dimensions in Detailed Profitability and Cost Management Applications
  4. About Detailed Profitability Dimensions

About Detailed Profitability Dimensions

Detailed Profitability enables you to use an existing relational database as the starting point for Detailed Profitability applications.

You create a Detailed Oracle Hyperion Profitability and Cost Management application in the Profitability Applications Console, and then deploy the application for use in Detailed Profitability models.

Caution:

Oracle recommends that the Detailed Profitability and Cost Management environment be created and maintained by experienced Database Administrators or System Administrators who have a good working knowledge of Detailed Profitability and Cost Management and the client's data model.

The dimensions are created and maintained in the Profitability Applications Console, and must exist before they can be used in Detailed Profitability models. Through the Profitability Applications Console, the Profitability and Cost Management Administrator can also select existing dimensions and members from other products, or create new dimensions and members specifically for the model. The common data can be shared and updated between multiple products and applications, such as Oracle Hyperion Planning. The dimensions and their members are available in the Detailed Profitability and Cost Management application after deployment.

The dimensions and members created in the Profitability Applications Console represent the structural elements of the business model. For general information about dimensions in Profitability and Cost Management, see Profitability and Cost Management Dimensions.

Caution:

Oracle recommends that you do not add or delete dimensions after the modeling process has begun; however, if new dimensions or members are added or deleted, you must redeploy the application. Take special care when deleting dimensions or members in a Detailed Profitability application as the action may have altered the Model Data Registration and invalidated the model.

The following types of dimensions can be used to create Detailed Profitability applications:

Within Detailed Profitability, you must register the user-defined measures dimensions for each stage table. These user-defined measure dimensions are business dimensions. Only two measures dimensions are registered for each application:

  • One Source measure for the registered Source stage table and its joined lookup tables

  • One Destination measure for the registered Destination stage table and its joined lookup tables

You may use the same measure for both stages, or select two different measures. See Registering Detailed Profitability Model Data.

Caution:

If the dimension members are not registered in Model Data Registration, the model validation fails.

For naming conventions for dimensions and members, see the Oracle Hyperion Profitability and Cost Management Administrator's Guide.

See Detailed Profitability Dimension Types for further information about specific dimension types.