Creating an Essbase Application Shell

  To create an Essbase application shell:

1. Launch Shared Services Console and log in as the user who is provisioned with the appropriate Lifecycle Management roles.

2. In Shared Services Console, expand Application Groups and select an Essbase application.

3. In the Artifact List tab, complete the following steps:

   • Expand Configuration, Properties and select Application Definition.xapr.

   • Expand Databases, and select the artifacts to migrate.

4. Click Define Migration and enter the requested information in the Migration Wizard. When you get to the Migration Summary dialog box, click Save Migration Definition.

5. Open the Migration Definition File. In the Options section do the following:

   • Add an option to create an application shell:

     <optionInfo name="operation" value="create"/>

   • Add an additional option in the target connection for cluster name:

     <optionInfo name="Cluster Name" value="<essbase server name>"/>

   The following is a sample migration definition file. The option to create an application shell and the option in the target connection for cluster name are shown in bold.

   <?xml version="1.0" encoding="UTF-8"?>
   <Package name="web-migration" description="Migrating Product to Product">
      <Credentials user=" " password=" "/<LOCALE>en_US</LOCALE>
      <Connections>
         <ConnectionInfo name="MyHSS-Connection1" type="HSS" description="Hyperion Shared Service connection"/>
         <ConnectionInfo name="AppConnection1" type="Application" product="ESBAPP" project="EssbaseCluster-1" application="Demo" HSSConnection="MyHSS-Connection1" description="Source Application"/>
         <ConnectionInfo name="AppConnection2" type="Application" product="ESBAPP" description="Destination Application" HSSConnection="MyHSS-Connection1" project="EssbaseCluster-1" application="lcmbso1"/>
      </Connections>
      <Tasks>
         <Task seqID="-1">
            <Source connection="AppConnection1">
               <Options/>
               <Artifact recursive="true" parentPath="/Configuration" pattern="*"/>
               <Artifact recursive="true" parentPath="/Databases/Basic " pattern="*"/>
            </Source>
            <Target connection="AppConnection2">
               <Options>
                  <optionInfo name="operation" value="create"/>
                  <optionInfo name="Cluster Name" value="<Hostname>"/>
                  <optionInfo name="overWriteArtifact" value="false"/>
                  <optionInfo name="restructureCube" value="Retain cube data"/>
               </Options>
            </Target>
         </Task>
      </Tasks>
   </Package>

6. Save the changes to the Migration Definition File.

7. Execute the migration using the command line utility utility.bat found in EPM_ORACLE_INSTANCE/bin as follows:

   utility.bat <Migration Definition File Name>