Relational Databases (for Detailed Profitability)

For Detailed Profitability applications, dimensional data and model definition are stored in the same relational database schema that is used to store dimensional data and model definitions for Standard Profitability applications. This schema, referred to as the Product Schema, is created when Oracle Hyperion Profitability and Cost Management is installed. Dimensional data is populated in the Product Schema when you deploy your application. Model definitions are stored in this schema as you build your 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 Standard Profitability 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 MS SQL Server databases are supported.