When data is imported into 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 MS SQL Server and Oracle Database. Use the create_staging.sql script to create the import tables in the new database.
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
POV
Driver
Driver Selection
Assignment
Assignment Rule Selection
The staging tables are created by the Profitability and Cost Management administrator (admin), using the format specified in Import Staging Tables.
Tables can be created manually or by running the SQL script create_staging.sql. Separate versions of this script are available for SQL and Oracle. After installation, the SQL scripts are included in the application folder. By default, the location is %EPM_ORACLE_HOME%\products\Profitability\database\Common\Oracle.
To import data, you must have the appropriate user role and security authorization. See the Oracle Hyperion Enterprise Performance Management System User and Role Security Guide.