Importing Data into Profitability and Cost Management

In This Section:

You can enter data directly into Profitability and Cost Management; however, the data entry may be very time-consuming. To facilitate the population of the application you can import data directly into Profitability and Cost Management using a set of import staging tables and import configurations.

Model data is imported from several sources:

Model metadata and dimensions are imported from the Performance Management Architect Dimension Library through EPM Workspace. See the chapter on importing metadata in the Oracle Hyperion Enterprise Performance Management Architect Administrator's Guide.
Model definition data is imported into Profitability and Cost Management. The data may be created in another application, such as Excel, and imported using the staging tables. See Import Staging Tables.
Model and end-user data can be imported and exported from Essbase. See the Oracle Essbase Database Administrator's Guide.
Model data and applications can be imported using Lifecycle Management. See the Oracle Hyperion Enterprise Performance Management System Lifecycle Management Guide.

Caution!

Oracle recommends that, before importing data, you create a backup directory of your databases in EPM Workspace and Essbase. See Backing Up Profitability and Cost Management Components.

You need to create an import configuration to specify which tables and data are to be imported. The configuration may be saved, and used multiple times to import the same set of data.

For detailed instructions, refer to these sections: