Application Migration and Use Cases

LCM Utility Use Cases

Oracle Analytics Cloud - Essbase provides a Lifecycle Management (LCM) command-line based utility that can be used to migrate Essbase on-premises applications, folders and elements using a .zip file, for import to the cloud service. The following releases are supported for migration: 11.1.2.3.0nn, 11.1.2.4.0nn, 11.1.2.4.5nn, 12.2.1, and later.

Not all application and database elements can be exported. See Application Elements - Supported or Unsupported.

LCM Utility Download and Typical Usage

Use Case: Migrate from 11.1.2.3.nnn On-Premises to the Cloud Service

  1. On the Applications home page, click Utilities Image of the Utilities icon., and download the LCM utility (EssbaseLCMUtility.zip).
  2. In the uncompressed downloaded file, run EssbaseLCM.bat (Windows) or EssbaseLCM.sh (Linux), based on the platform on which you want to run the utility.

    Note:

    You can execute the file from any location against a remote cloud service instance.
  3. Manually convert the on-premises Essbase application to Unicode before exporting it to a .zip file.
  4. Run the LCM export command to download the on-premises Essbase application and its elements to the specified .zip file.
  5. To import the application into the cloud service, use the Oracle Analytics Cloud - Essbase CLI tool to upload the .zip file to a target cloud service application.

  6. Log into the cloud service to see the application and cube on the Applications home page.

The LCM import and export commands are described in Migrating Cloud Service Applications.

  1. Download the LCM utility from the cloud service and execute it in the system running Essbase 11.1.2.3.nnn. This use case is similarly relevant to Essbase 11.1.2.4.nnn.
  2. Export the required source application using the utility. This includes application-level elements.
  3. In the exported .zip file, if a partition exists in the source application, then edit the partition XML to correct any partition settings.
  4. Import the .zip file into the cloud service using the CLI tool.

    Note:

    You must move server-level substitution variables, which are used in on-premises applications, to the application level prior to import.
  5. After importing using CLI, perform the following in the Oracle Analytics Cloud - Essbase user interface:
    • Assign calculation scripts to relevant users
    • Assign cloud-based user roles to users