Scribd Logo
Upload

Welcome to Scribd!

  • 9K views

    Essbase Cube Migration 11.1.1.3 To 11.1.2

    Uploaded by

    Amit Sharma
    This document will guide step by step process to migrate the Hyperion Essbase cube from 11.1.1. To 11.1.2. The Migration Check List will assist you to ensure all Essbase artifacts are migrated successfully.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd

    Essbase Cube Migration 11.1.1.3 To 11.1.2

    Uploaded by

    Amit Sharma
    9K views20 pages
    This document will guide step by step process to migrate the Hyperion Essbase cube from 11.1.1. To 11.1.2. The Migration Check List will assist you to ensure all Essbase artifacts are migrated successfully.

    Original Title

    Essbase Cube Migration 11.1.1.3 to 11.1.2

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document will guide step by step process to migrate the Hyperion Essbase cube from 11.1.1. To 11.1.2. The Migration Check List will assist you to ensure all Essbase artifacts are migrated successfully.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    9K views20 pages

    Essbase Cube Migration 11.1.1.3 To 11.1.2

    Uploaded by

    Amit Sharma
    This document will guide step by step process to migrate the Hyperion Essbase cube from 11.1.1. To 11.1.2. The Migration Check List will assist you to ensure all Essbase artifacts are migrated successfully.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 20

    Migrating Hyperion Essbase Cube 11.1.1.3 to 11.1.

    Description:
    This document will guide step by step process to migrate the Hyperion Essbase cube from 11.1.1.3 to 11.1.2. The migration check list will assist you to ensure all Essbase artifacts are migrated successfully.

    History:
    Version 0.1 0.1 Description Change Initial Draft Review 1st Author Gaurav Shrivastava Amit Sharma Publish Date 25-May-2011 25-May-2011

    Business Intelligence Solution Providers | Life Cycle Management 11.1.1.3 to 11.1.2

    Table of Contents
    1. Life Cycle Management3 2. Migration Types LCM Utility4 a. Application to Application Migration..4 b. Application to File System Migration7 3. List of Artifacts...9 4. Backed up artifact..13 5. File system to application....17 6. Migration Check List.23 7. Log File27

    Business Intelligence Solution Providers | Life Cycle Management 11.1.1.3 to 11.1.2

    Life Cycle Management


    In Essbase one of most attractive features of version 11.1.1.3 is Life Cycle Management. You can perform LCM tasks through shared service. URL for opening shared services http://<server name> :28080/interop/index.jsp

    Life cycle management migrate all applications or individual artifacts between environments. If there is common environment, then you can migrate directly from application to application. Shared service used for migration when there is common environment. You can take back up of all artifacts through Life Cycle Management utility.
    1. 2. 3. 4. 5. 6. 7. 8. 9.

    Definitions of all databases within the applications Outlines Substitution Variables Rule Files Calculation Scripts Report Scripts Excel Files Location Aliases Security Filters

    Business Intelligence Solution Providers | Life Cycle Management 11.1.1.3 to 11.1.2

    Migration Types LCM Utility Use application to file system then from file system to the targeted application, when you are performing migration from one version to another version. Application to File System Migration If you have multiple Essbase applications registered in different shared services. Then this utility migrate all the necessary artifacts on to the file system. Then you can move the extracted artifacts to the target machine. In the next step again use the utility from file system to the target application.

    Application to file system


    This is the Essbase source application and database to perform LCM operations.

    All file are in the Mydata folder before migration.

    Business Intelligence Solution Providers | Life Cycle Management 11.1.1.3 to 11.1.2

    Log in to shared service.

    This is the Group of application for different products.

    List of Artifacts
    The source application is Bcub and Mydata is source database. This is the list of artifacts, select artifacts to be migrated.

    Business Intelligence Solution Providers | Life Cycle Management 11.1.1.3 to 11.1.2

    Select all calculation script, Excel files, location aliases and report scripts.

    Select rule files, Security file, variable and Text file. After all selection of artifacts, click on Define migration.

    Business Intelligence Solution Providers | Life Cycle Management 11.1.1.3 to 11.1.2

    Source Application for migration Click next

    Select the destination for migration; you can simply migrate to any application into file system. New folder will create inside the native directory. <C:\user_projects\epmsystem1\import_export\admin@Native Directory>

    Business Intelligence Solution Providers | Life Cycle Management 11.1.1.3 to 11.1.2

    View of destination place

    Complete migration summary for migration. Now execute migration then click ok or you can launch migration status report ..

    Migrated report status

    Newly created folder has all migrated artifacts.


    Business Intelligence Solution Providers | Life Cycle Management 11.1.1.3 to 11.1.2 8

    Backed up artifacts
    All artifacts folders backed up successfully. \import_export\admini@Native Directory\ folder. Backup files stored in

    All backup files are in XML format. You can move all this files in other environment; were ever you want.
    Business Intelligence Solution Providers | Life Cycle Management 11.1.1.3 to 11.1.2 9

    Calc Script

    Excel Files

    Report Scripts

    Rule Files

    Security Files

    Substitution Variables
    Business Intelligence Solution Providers | Life Cycle Management 11.1.1.3 to 11.1.2 10

    Text Files

    All artifacts backed up in to file system.

    Some other information also stored inside the info folder. Listing Listing file save the entire folder detailed information.

    Open listing file into wordpad and can see the listing file information.

    Business Intelligence Solution Providers | Life Cycle Management 11.1.1.3 to 11.1.2

    11

    Sourceinfo Source information file save application version, variable, metadata information.

    File system to application


    Business Intelligence Solution Providers | Life Cycle Management 11.1.1.3 to 11.1.2 12

    All backup of artifacts is stored in the Mydata folder. Select all artifacts to recover application from file system to Essbase application.

    Copy this newly created folder and past inside the native directory of destination server folder. Hyperion 11.1.1.3 Source folder

    Hyperion 11.1.2 Targeted folder

    Login in to shared service

    Business Intelligence Solution Providers | Life Cycle Management 11.1.1.3 to 11.1.2

    13

    Open file System you will find same folder information through shared services, which you pasted inside the native directory.

    Select all migrated artifacts and click on define migration.


    Business Intelligence Solution Providers | Life Cycle Management 11.1.1.3 to 11.1.2 14

    Source application

    Destination application

    Destination application information


    Business Intelligence Solution Providers | Life Cycle Management 11.1.1.3 to 11.1.2 15

    If your performing LCM migration second time for the same application then you can select Overwrite Artifacts option.

    Migration summary Click on Execute Migration then Launch Migration Status Report.

    Migration completed successfully

    Open application and check migrated artifacts.


    Business Intelligence Solution Providers | Life Cycle Management 11.1.1.3 to 11.1.2 16

    Calc script, excel files and location aliases

    Report script and rule files

    All artifacts have migrated from 11.1.1.3 to 11.1.2.

    Security file, substitution variables and text files


    Business Intelligence Solution Providers | Life Cycle Management 11.1.1.3 to 11.1.2 17

    Migrated application outline.

    Cross check the all files are migrated in to new application. This folder shows migrated files.

    Migration Check List


    Business Intelligence Solution Providers | Life Cycle Management 11.1.1.3 to 11.1.2 18

    You can create one migration check list, and check the status after migration.

    Migration Check List

    Log File
    Business Intelligence Solution Providers | Life Cycle Management 11.1.1.3 to 11.1.2 19

    One log file creates during migrating application artifacts using LCM utility. This log file keeps all the information of migration process.

    Business Intelligence Solution Providers | Life Cycle Management 11.1.1.3 to 11.1.2

    20

    You might also like