About Staging Tables
When data is imported into Oracle Hyperion Profitability and Cost Management, users create the staging tables that provide the predefined structure to manage the import.
To import model data from relational databases into Profitability and Cost Management, you must create a set of staging tables in a separate database schema from the location in which the Profitability and Cost Management database tables were created to format the information for use in the application.
Caution:
Do not create import staging tables inside the product schema. Modifications of the product schema are not only unsupported, but can produce unpredictable results.
The tables are created using a relational database, such as Oracle or SQL Server, to organize the data into a format that can be easily matched to the application. Staging database scripts are available for Microsoft SQL Server and Oracle Database after installation in the installation folder. By default, the location is %EPM_ORACLE_HOME%\products\Profitability\database\Common\
. Use the appropriate script for your application type to create the staging tables in the new database:
-
For Standard Profitability applications, use the
create_staging.sql
script. -
For Detailed Profitability applications, use the
create_dp_staging.sql
script.
You can create all tables simultaneously, or create only the tables that you want to import. You must populate at least one of the following data groups:
-
Stages (For Standard Profitability only)
-
POV
-
Driver
-
Driver Selection
-
Driver Exception
-
Assignment (For Standard Profitability only)
-
Source Assignment Rule Associations
-
Calculation Rules (For Detailed Profitability only)
The staging tables are created by the Profitability and Cost Management administrator (admin), using the formats specified in these sections:
To import data, you must have the appropriate user role and security authorization. See the Oracle Enterprise Performance Management System User Security Administration Guide.