1. Administrator's Guide
  2. Importing Data into Profitability and Cost Management
  3. About Importing Data

About Importing Data

You can enter data 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 data directly into Profitability and Cost Management Standard and Detailed Profitability applications using a set of import staging tables and import configurations.

Model data is imported from several sources:

  • 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.

  • Model and end-user data can be imported and exported from Oracle Essbase for Standard Profitability applications only. See the Oracle Essbase Database Administrator's Guide.

  • Model data and applications 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, you create a backup directory of your databases in Oracle Hyperion Enterprise Performance Management Workspace and Essbase.

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.