Importing Detailed Profitability Staging Tables

You can enter data and model information directly into Oracle Hyperion Profitability and Cost Management; however, the data entry may be very time-consuming.

To facilitate the population of the application, you can import model definitions, such as POVs, drivers, driver selections, assignment rule selections, and calculation rules, directly into Profitability and Cost Management using a set of import staging tables and import configurations.

Note:

Dimensions, costs and driver data cannot be imported from staging tables.

Model data is imported from several sources:

• Model structure and metadata (measures and dimensions) are imported from the Profitability Applications Console through Oracle Hyperion Enterprise Performance Management Workspace.

• Model definition data is imported from staging tables.

• Model data and applications can be imported using Oracle Hyperion Enterprise Performance Management System Lifecycle Management. See the Oracle Hyperion Enterprise Performance Management System Lifecycle Management Guide.

• Model data is imported using Oracle Enterprise Performance Management System

Caution:

Oracle recommends that, before importing data or artifacts, you create a backup directory of the databases in EPM Workspace. Contact the administrator for assistance.

In order to import staging tables, you must create an import configuration to specify which tables are to be imported. The configuration, which can be saved, can be used multiple times to import the same set of data. When importing the complete model, there are table dependencies that apply; however, these dependencies are not applicable if you are only importing sections of the model

For detailed instructions on creating staging tables and import configurations, see the Oracle Hyperion Profitability and Cost Management Administrator's Guide.