You can enter data and model information 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 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 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 Performance Management Architect through EPM 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 from Essbase.
Model data is imported using Oracle Hyperion Enterprise Performance Management System
Caution! | Oracle recommends that, before importing data or artifacts, you create a backup directory of your databases in EPM Workspace and Essbase. Contact your 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.