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.
- 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
- 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.
- 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.