8 Working with Detailed Profitability Databases

For Detailed Profitability applications, the dimensional data and model definition are stored in the same relational database schema that is used to store dimensional data and model definitions for Management Ledger applications. This schema is referred to as the Product Schema, and it is created when Profitability and Cost Management is installed. Dimensional data is populated in the Product Schema when you deploy the application from the Profitability Applications Console. Model definitions are stored in this schema as you build the model.

For Detailed Profitability applications, the business data upon which allocations are performed is also stored in the relational database (not in Oracle Essbase as is the case for Management Ledger applications). This data resides in a separate database schema called the Model Data Schema. The Model Data Schema is user-defined and must reside in the same database instance as the Product Schema. Only Oracle and Microsoft SQL Server databases are supported.

After deploying the application, the dimensions and members are mapped to columns and registered to the application tables in Oracle Hyperion Profitability and Cost Management. For information on Detailed Profitability dimensions, see Working with Detailed Profitability and Cost Management Dimensions and Metadata.

Table 8-1 Detailed Profitability and Cost Management Database Schemas

Schema Type	Information Type Stored
Model Data Schema	Dimension Hierarchies Cost Data Revenue Data Driver Data Profit Object Data Currency Rates
Product Schema	Dimensions Stage Definitions POV Definitions Driver Definitions Driver Selections Assignment Rules Assignment Rules Selections Model Preferences Table Registrations Calculation Rules