1. Administrator's Guide
  2. Working with Detailed Profitability
  3. Product Schema

9 Product Schema

Detailed Profitability applications shares the same Product Schema that holds the Oracle Hyperion Profitability and Cost Management system tables and that is created during installation.

The Profitability and Cost Management UI and the Detailed Profitability calculation engine connect to this schema. Reporting views are created in the Product schema during model development and model calculation.

Access to this schema is typically restricted to application administrators and Database Administrators. Grants on the reporting views are automatically made to the Model Data Schema and synonyms for them are automatically created in the Model Data Schema. The synonyms expose them to users who have access to that schema without having to grant them privileges on the Product Schema.

After installation, Detailed Profitability requires that these system privileges (or roles that include them) be granted to the Product Schema:

  • For Oracle database, Detailed Profitability requires that these system privileges (or roles that include them) be granted to the Product Schema:

    • CREATE TABLE

    • CREATE VIEW

    • CREATE ANY SYNONYM

    • DROP ANY SYNONYM

  • For Microsoft SQL Server, Detailed Profitability requires that these system privileges (or roles that include them) be granted to the Product Schema:

    • CREATE TABLE

    • CREATE VIEW

    • ALTER or CONTROL on the Model Data Schema to the product schema (so that the product schema has the ability to change objects in the Model Data schema)

    EXCEPTION: If the Product Schema is an Administrator user such as "dbo" or "sa" it will already have the above privileges. In this case it is not necessary to perform the following grants.

    Note:

    Do not grant the SYSADMIN role to the user associated with the Profitability and Cost Management product schema. It will change the default schema for that user, which must remain set as the Profitability and Cost Management product schema.

The CREATE TABLE and CREATE VIEW privileges allow Profitability and Cost Management to create system-generated tables and reporting views in the Product Schema during model development and during model calculation.

The CREATE ANY SYNONYM and DROP ANY SYNONYM privileges allow Profitability and Cost Management to manage the synonyms in the Model Data Schema for the system-generated reporting views that are created in the Product Schema.

Note:

If granting either of these system privileges is a security concern for your organization, you may withhold these privileges and manually create the synonyms in the Model Data Schema for the system-generated reporting views. This option enables you to expose them to business data users who only have access to the Model Data Schema.