1. Administrator's Guide
  2. Working with Standard Profitability
  3. Working with Databases for Standard Profitability

5 Working with Databases for Standard Profitability

For Oracle Hyperion Profitability and Cost Management, you require both a relational database and an Oracle Essbase database. Details about these databases and connection information are specified on the System Information tab of the Model Summary in the application. For details, see the Oracle Hyperion Profitability and Cost Management User's Guide.

When you create an application, tables are populated with appropriate values in the Profitability and Cost Management relational database. The Essbase application is created during model deployment in Profitability and Cost Management. Each database stores specific information, as shown in Table 5-1.

Table 5-1 Profitability and Cost Management Databases

Database Type Information Type Stored
Essbase

  • Dimension Hierarchies

  • Cost Data

  • Revenue Data

  • Driver Data

  • Currency Rates

  • Calculation Scripts

Product Relational Database

  • Dimensions

  • Stage Definitions

  • POV Definitions

  • Driver Definitions

  • Driver Selections

  • Assignments

  • Assignment Rules

  • Assignment Rules Selections

  • Model Preferences

Profitability and Cost Management uses the information from the driver definitions, driver selections and assignments defined in the relational database to create calculation scripts in the Essbase application. The calculation scripts perform the required data allocations.