Preparing Essbase Applications for Upgrading

Use Oracle Hyperion Enterprise Performance Management System Lifecycle Management to export Oracle Essbase applications (metadata and data) from Release 11.1.2.4.xxx.

To export applications from Essbase Release 11.1.2.4.xxx:

1. Log in to Oracle Hyperion Enterprise Performance Management Workspace.
2. From the Navigate menu, select Administer, and then select Shared Services Console.

3. In the View pane, expand the Application Groups node, expand EssbaseCluster-N, and then select the application to export.

4. Click Select All.
5. Click Export.
6. In the Export dialog box, in File System Folder, enter a name for the artifacts to be exported, and then click Export.

   Specify a meaningful name, such as essbase_application_name_11.1.2.4.

   Check the status column and wait for Completed status.

7. Expand the File System node in Shared Services Console, right-click the Essbase folder you created, and then select Download.

   The Download option is available only if the folder size is less than or equal to 2 GB. Because the Essbase ZIP file is likely larger than 2GB, use an alternate method to access the file. For example, use a method such as FTP to transfer the folder to a location accessible to the Release 11.2 environment. By default, the exported folder is stored in EPM_ORACLE_INSTANCE\import_export.

8. In the File Download dialog box, click Save to save the application artifacts as a ZIP file.

   The entire contents of the ZIP file is downloaded as one file.

9. Copy the ZIP file to a location accessible to the Release 11.2 environment.
10. Repeat these steps for each application in EssbaseCluster-N.
11. Optionally, for Oracle Hyperion EPM Architect-based Essbase applications, if you want to manage your metadata in Oracle Data Relationship Management in Release 11.2, see Exporting Essbase Metadata from Performance Management Architect.