Table of Contents:
This document is a tutorial on how to migrate an Oracle Hyperion Planning application from one environment to another. The steps include artifacts and data of Planning and related components including Oracle Hyperion Calculation Manager, Oracle Essbase Server, Oracle Hyperion Financial Reporting, and Oracle Hyperion Shared Services artifacts.
There are two exercises in this document that walk you through the steps needed to migrate artifacts and data from one environment to another.
This exercise provides steps to import an entire Planning Suite application. – 15 Minutes
This exercise provides steps to export application artifacts using Oracle Hyperion Enterprise Performance Management System Lifecycle Management and to export Essbase data using Oracle Essbase Administration Services. – 30 Minutes
Use the Shared Services native admin user to perform the procedures in these exercises.
Before you start these exercises, you will need an environment. To build this environment, follow the steps in the guide titled Oracle Enterprise Performance Management System Rapid Deployment of Oracle Hyperion Planning in Development Environments located at: http://docs.oracle.com/cd/E17236_01/nav/portal_1.htm.
You must use the 7-Zip software to unzip the sample data used in these exercises. Please download it before proceeding. Using other archiving utilities might result in migration errors.
You will need some sample data for these exercises. To download the sample data:
Go to the Oracle Documentation Library on Oracle® Technology Network (http://www.oracle.com/technology/documentation/epm.html).
Under Oracle Enterprise Performance Management System Release 220.127.116.11, click View Library.
On the Foundation Services tab, select the file titled Migrating Oracle Hyperion Planning Applications - Data, and unzip its content to EPM_ORACLE_INSTANCE\import_export.
If the import_export folder does not exist, you must create it
You must use 7-Zip to unzip the contents of the file. The name of the actual zip file is epm_migrate_planning_app_data.zip.
To import Planning Suite artifacts using Lifecycle Management:
You can also log in to Oracle Hyperion Shared Services Console by accessing http://<host>:<port>/interop/index.jsp.
Note that you can also explore and check out artifacts in the File System folder before importing by expanding the folder and then browsing in the right-hand pane. The File System folder has application-related content from Planning, Calculation Manager, Financial Reporting, Essbase, and Shared Services.
Log in to Oracle Hyperion Enterprise Performance Management Workspace and validate that the Planning application has been created successfully. You can also validate the Oracle Hyperion Calculation Manager business rules and the reports in the Reporting and Analysis repository.
To import Planning data using MAXL:
If you are using Essbase Administration Services Console for the first time, you must add your Oracle Essbase server first.
import database FinSrv.HCP data from data_file '<EPM_ORACLE_INSTANCE>\import_export\HCM.dat' on error write to 'c:\HCP.log'
To export Planning Suite artifacts and data:
In the right pane, you should see all the Oracle Hyperion Shared Services artifacts.
Your screen should look similar to the following:
In the left pane, expand Application Groups, and then EssbaseCluster-1. Select the EssbaseCluster-1 node. You should now see the Substitution Variables folder of EssbaseCluster-1 listed in the right pane. Select all the artifacts.
You should now see all the Oracle Hyperion Reporting and Analysis artifacts in the right hand pane.
These are the Oracle Hyperion Financial Reporting artifacts related to the FinSrv application.
This launches the Migration Status Report.
The migrated content is available at EPM_ORACLE_INSTANCE/import_export.