In order to import model data from relational databases into Profitability and Cost Management, you must create a set of staging tables in the source database to format the information for use in the application. Model data and metadata for the import are loaded into the staging tables in an Oracle or MS SQL Server database. To import data and metadata using these staging tables, see the Oracle Hyperion Profitability and Cost Management User's Guide.
The Profitability and Cost Management staging table schema has defined table names and contents.
Caution! | Do not modify the staging table names, columns or overall table structure, as this may cause the import to fail. |
A unique record ID is required for every staging table. This field is required, and is entered by the user, whether through an automatic program, script or manual entry.
Error messages for each table are self-explanatory, and are presented in the format ERROR_<Error Condition> For example, ERROR_NAME_NOT_FOUND, or ERROR_DUPLICATED_DIMENSIONS.
Use the schema tables in this appendix to create your staging tables: