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.

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.