Oracle® Enterprise Performance Management System

Migrating Oracle Hyperion Planning Applications


Copyright © 2011, 2012, Oracle and/or its affiliates. All rights reserved.

Authors: EPM Information Development Team

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:


Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle America, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.

Table of Contents:

About This Document

Setting Up the Environment

Exercise 1: Importing Planning Suite Artifacts and Data

Exercise 2: Exporting Planning Suite Artifacts and Data

About This Document

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.


Use the Shared Services native admin user to perform the procedures in these exercises.

Setting Up the Environment

Building an Environment

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:

Downloading Sample Data


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:

  1. Go to the Oracle Documentation Library on Oracle® Technology Network (

  2. Under Oracle Enterprise Performance Management System Release, click View Library.

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

Step 1: Import Planning Suite Artifacts Using Lifecycle Management

  To import Planning Suite artifacts using Lifecycle Management:

  1. Log in to Oracle Hyperion Enterprise Performance Management Workspace and select Navigate, then Administer, and then Planning Administration. Create a datasource with the name FinSrv.

    Manage Data Source tab in the Classic Application Wizard showing a FinSrv datasource being created
  2. Click OK to save the datasource.

  3. While still in EPM Workspace, select Navigate, then Administer, and then Shared Services Console.

    You can also log in to Oracle Hyperion Shared Services Console by accessing http://<host>:<port>/interop/index.jsp.

  4. Expand File System, right-click FinSrvApplicationSuite, and select Import.

    File System node expanded with Import selected for FinSrvApplicationSuite

    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.

  5. Select OK when asked if you want to proceed with the import.

    Import dialog box where you can click OK to proceed to the import
  6. Wait for the import operation to complete.

    Status showing whether the import operation has completed.
  7. 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.

    Planning Application Library

Step 2: Import Planning Data Using MAXL

  To import Planning data using MAXL:

  1. Launch Essbase Administration Services Console by accessing http://<EAS_SERVER_NAME>:<port>/easconsole.


    If you are using Essbase Administration Services Console for the first time, you must add your Oracle Essbase server first.

  2. Select File, then Editors, and then MaxL script editor.

  3. Execute the following command:

    import database FinSrv.HCP data from data_file '<EPM_ORACLE_INSTANCE>\import_export\HCM.dat' on error write to 'c:\HCP.log'

    Essbase Administration Services Console with the import command displayed.

Step 1: Exporting from the Source

  To export Planning Suite artifacts and data:

  1. Log in to Oracle Hyperion Shared Services Console (http://<host>:<port>/interop/index.jsp).

  2. Expand Application Groups, then Foundation, and then Shared Services.

  3. Click the Shared Services node.

    In the right pane, you should see all the Oracle Hyperion Shared Services artifacts.

    Artifact list showing the Shared Services artifacts
  4. In the right pane, expand Native Directory, and select the users and groups artifacts.

  5. Expand Assigned Roles, and then Shared Services for your Oracle Hyperion Planning application, and then select the Assigned Roles artifact named after the application, FinSrv, Reporting and Analysis.

    Your screen should look similar to the following:

    Shared Services Console showing the assigned roles for your Planning application.
  6. In the left pane, select Foundation, and then Calculation Manager.

  7. In the right pane, expand Planning and select the FinSrv application.

    Shared Services Console showing Planning, FinSrv selected.
  8. In the left pane, expand the HP Application group and explore the FinSrv application. You should be able to see all the artifacts of this application in right pane. Select all the artifacts.

    Shared Services Console showing all the artifacts selected.
  9. 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.

    Artifact List tab showing the EssbaseCluster-1 node selected.
  10. In the left pane, expand the Reporting and Analysis application group and select Reporting and Analysis.

    You should now see all the Oracle Hyperion Reporting and Analysis artifacts in the right hand pane.

  11. In the right pane, expand Repository Objects and select FinSrv; then, expand Security and select all users.

    These are the Oracle Hyperion Financial Reporting artifacts related to the FinSrv application.

    Shared Services Console showing Repository objects, FinSrv, and Security selected.
  12. Click Export.

  13. In the Export dialog box, enter the File System Folder name and click Export.

    Export dialog box showing a sample file system folder.

    This launches the Migration Status Report.

  14. Wait for the migration to complete.

    Sample Migration Status report

    The migrated content is available at EPM_ORACLE_INSTANCE/import_export.

Step 2: Exporting Planning Data from MAXL

  To export Planning data from MAXL:

  1. Launch Oracle Essbase Administration Services Console.

  2. Select File, then Editors, and then MaxL script editor.

  3. Execute the following command:

    export database FinSrv.HCP data to data_file '<EPM_ORACLE_INSTANCE>\import_export\HCM1.dat';

    Essbase Administration Service Console with the export command displayed

Step 3: Re-export Artifacts From the Source

  To re-export artifacts from the source system:

  1. Right-click FinSrvApplicationSuite and select Repeat Export.

    Shared Services Console showing FinSrvApplicationSuite highlighed with Repeat Export selected.
  2. When prompted for a File System Folder name, specify a name or leave the default name.

    Export dialog box with a sample File System Folder name.