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.