Importing Standard Profitability Data and Artifacts

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, stages, drivers, driver selections, assignments, and assignment rule selections, directly into Profitability and Cost Management using a set of import staging tables and import configurations.

Note:

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

Model data is imported from several sources:

• Model definition data is imported from staging tables.

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

Caution:

Oracle recommends that, before importing data or artifacts, you create a backup directory of the databases in Oracle Hyperion Enterprise Performance Management Workspace and Oracle Essbase. 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.