Understanding Detailed Profitability Product Architecture

7 Understanding Detailed Profitability Product Architecture

Accessed through Oracle Hyperion Enterprise Performance Management Workspace, Detailed Profitability is an analytical application that uses data in a relational database. The application enables business users to model their business for profitability and cost management, and use that model information to create a relational database where model information, existing data, and results calculated by the application are stored. Data, both entered and calculated, for the Detailed Profitability model is housed in relational databases.

Oracle Hyperion Profitability and Cost Management leverages Oracle Hyperion Shared Services for the centralized management of application metadata and security.

Figure 7-1 Detailed Profitability Architecture

The model metadata from Workspace is used in the creation of the Detailed Profitability and Cost Management model, and the calculated results can be output in a variety of reporting and analysis tools.

Application administrators create the Profitability and Cost Management dimensions using the Profitability Applications Console. (See Creating Applications Using the Profitability Applications Console). User access is managed centrally with Shared Services. When the dimension metadata is ready, it is deployed to a Profitability and Cost Management application, or model.

The model design contains the information needed to generate the SQL Statements required to perform calculations within the database. Each model requires access to the following schemas within the database:

A schema, referred to as the Product Schema, for storing the model design. See Product Schema.
A schema, referred to as the Model Data Schema, for storing existing data and the results of the model calculations. See Model Data Schema for Detailed Profitability.