How to download and Migrate BI Publisher reports between environments

 

040617_0339_Howtodownlo1 Step by Step instruction to download and migrate BI Publisher reports between environments

 

In this section, we walk through how to download and migrate BI Publisher reports between, for example, Dev to a Test environment. Also, I have covered how to copy or move reports and data models between catalog folders.

 

Version Used: BI Publisher 12C

 

Understand the BI Publisher Extensions

Below are the BI Publisher file extension names of catalog objects. We are going to see each file when Migrate BI Publisher reports

Catalog Object File Extensions
Data Model .xdmz
Report .xdoz
Report Folder .xdrz

 

Migrate BI Publisher Reports as a bulk

 

Here are detailed how to migrate the report folder from one environment to another:

 

1. Login into BI Publisher as BI Administrator. The default URL is http://HOST:PORT/xmlpserver

 

2. Click on the Catalog, Select the folder that contains the report you want to migrate, Click on the Download link at the bottom. The reports will be downloaded as a format FOLDER.xdrz. This file will contain all your catalog objects under that folder, ex: report, folder, and data models.

 

040617_0339_Howtodownlo2 Step by Step instruction to download and migrate BI Publisher reports between environments

 

3. Go to the environment where you want to import the BI Publisher reports; Make sure to Select the root folder, Select the Upload link in the bottom, Choose the XDRZ file that you downloaded above step, Toggle on Overwrite Existing File, and Click the button Upload 

 

040617_0339_Howtodownlo3 Step by Step instruction to download and migrate BI Publisher reports between environments

 

4. That’s it. We are done migrating the reports as a bulk. Check the timestamp of the report you migrated and open the reports to verify it migrated correctly

 

040617_0339_Howtodownlo4 Step by Step instruction to download and migrate BI Publisher reports between environments

 

2) Migrate individual report in BI Publisher

 

Here we are going to download the report between environments. A report requires data model to run, so we need to download report and data model

 

2.1) Download Report: Go to the catalog folder, select the report you want to download and click the link Download. The report will be downloaded as REPORT.xdoz

 

040617_0339_Howtodownlo5 Step by Step instruction to download and migrate BI Publisher reports between environments

 

2.2) Download Data Model: Select the Data Model, Click the link Download. The file will get downloaded as DATA_MODEL.xdmz

 

040617_0339_Howtodownlo6 Step by Step instruction to download and migrate BI Publisher reports between environments

 

2.3) Upload Data Model: Go to the environment where you want to import reports, click on the upload link, upload the data model file, Toggle on Overwrite Existing File, and click the button Upload

 

040617_0339_Howtodownlo7 Step by Step instruction to download and migrate BI Publisher reports between environments

 

2.3) Like below, upload the Report file XDOZ

 

040617_0339_Howtodownlo8 Step by Step instruction to download and migrate BI Publisher reports between environments

 

2.3) Edit the report

 

040617_0339_Howtodownlo9 Step by Step instruction to download and migrate BI Publisher reports between environments

 

2.4) Click on the Search Icon, Select the data model, Click Open. Hit the save icon on the right side. Open the report to verify the report

 

040617_0339_Howtodownlo10 Step by Step instruction to download and migrate BI Publisher reports between environments

 

3. How to copy report and data model between folders in BI Publisher

 

Here we have detailed how to move report and data model between folders in BI Publisher

 

3.1) Select the data models and reports you want to copy, Select the link Copy or Cut

 

040617_0339_Howtodownlo11 Step by Step instruction to download and migrate BI Publisher reports between environments

 

3.2) Select the folder where you want to paste or move, Click the link Paste as shown below. That’s it

 

040617_0339_Howtodownlo12 Step by Step instruction to download and migrate BI Publisher reports between environments

govindan Step by Step instruction to download and migrate BI Publisher reports between environments
Connect me

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply šŸ™‚
govindan Step by Step instruction to download and migrate BI Publisher reports between environments
Connect me
By | 2017-04-05T23:24:29+00:00 April 5th, 2017|Categories: OBIEE|Tags: , , , |0 Comments
Like us on Facebook.
Connect!