Using Import Staging Tables

To import model data from relational databases into Oracle Hyperion Profitability and Cost Management, you must create a set of staging tables in a database schema that is separate from the Profitability and Cost Management product schema.

You can re-use the same schema used as the Model Data Schema for Detailed Profitability. You then populate these staging tables with the details of the application artifacts to be imported.

Caution:

Do not modify the product schema.

Staging database scripts are available for Microsoft SQL Server and Oracle Database. Use the appropriate script to create the import tables in a new database schema:

Note:

Staging imports for Standard applications cannot work properly if two stages have identical dimensions but in a different order. For example:

Stage 1: Product, Customer, Entity

Stage 2: Customer, Entity, Product

When two stages have the same dimensionality, the order must be identical also.