Process to Migrate Reports using Migration Manager

We often face many difficulties while migration reports. Generally user’s exports all report Rpt files using SQL queries and then import all report one by one manual.

During this process we may miss some report and even lookups, this will lead to loose of time.

IBM Maximo had provided a simple solution to migrate the report.

Note: Both Source and target environment should be similar.

Below are the steps involved:

Process to Create Package in the source system

• Go To System Configuration --> Migration --> Migration Groups.
• Search for the group ‘REPORTING’.
• Duplicate the Migration group ‘REPORTING’ and rename it as REPMIGGROUP.
• Delete ‘DMKPIMAIN’ from the new Migration Objects.
• Delete ‘APPLICATION’ and DATADICTIONARY’ from Dependencies and save.
• Go To System Configuration --> Migration --> Migration Manager.
• Create new Package definition by name ‘REPMIGMGR’ with processing action    of   ‘AddChange’ and type of ‘SNAPSHOT’.
• Select ‘REPMIGGROUP’ under Migration groups.
• Provide the where class to filter reports reportname in 'buyer_activity_report.rptdesign', 'buyer_audit_report.rptdesign',….enter all reports that you want to be in the     package’)
• Change status on the package to APPR.
• Activate Package from Select Action.
• Go To ‘Package’ tab, and click on ‘Create’ button under Packages section.
• Click on ‘Distribute’ BUTTON to save the package to a physical location on application server machine. Select the target to save package.
• If the target is unavailable. Create the target using Select action--> manage    targets.

Process to Deploy Package in the target system

• In the Target environment, go To Migration Manager Application.
• From select action from the list tab, Turn Admin mode ON using ‘Manage Admin Mode’ option.(Note: Turn the Admin Mode Off once the deployment is done)
• Upload the new package using Select Action, Upload Package action.
• From Select Action, Deploy Package option to deploy the package uploaded in the above step.
• Once the deployment is complete, Go To Report Administration Generate Request Page for all the reports and set security as applicable.
• Verify that Report security has been set as applicable.