OBIEE RPD Merge using XML Patch - How to generate and Merge RPD XML Patch

There is a simple method where you could compare the master RPD and latest RPD and You could generate a XML file which could have all your changes and that could be easily merged or migrated to another environment RPD.

Here is the steps for the same. First We will see how to Prepare the XML file and then next , We will see how to merge the same. 

Need OBIEE 12c Samplesales RPD, Just Click Here. RPD Password: Admin123

How to generate a XML patch using the Administration Tool:

Step 1:  

In the Administration Tool, Open the latest RPD in offline mode. In other words, open the updated repository that contains the changes you want to put in the patch.

Step 2: 

In the Administration Tool, Select File then select Compare.

Step 3: 

Select the Master or Original repository. Select Repository from the submenu to select a binary repository file in RPD format, 

or select XML to select a set of MDS XML documents.

Step 4: 

In the Open Offline dialog, enter the repository password and click OK.

Step 5a(optional): It is a good practice to equalize your changes to clean up underlying object IDs before generating a patch.

Step 5b: In the Compare repositories dialog, review the changes between the repositories. Then, click Create Patch. In the Create Patch dialog, 

enter a name for the patch file (for example, my_patch.xml) 

and click Save.

How To Merge the XML in the Target RPD:

Step 1:In the Administration Tool, open the modified Oracle BI repository in offline mode. In i.e., open the repository on which you want to apply the patch.

Step 2:Select File, then select Merge. The Merge Repository Wizard appears.  For Merge Type, select Patch Repository Merge.

Step 3: Select the original parent repository by clicking Select next to Original Master Repository. 

Select Repository from the submenu to select a binary repository file in RPD format, or select XML to select a set of MDS XML documents.

Step 4:Enter the repository password for the original repository.

Step 5: Click Select next to Patch File. Browse to select the patch file you want to apply, 

then click Open. The patch file must be in XML format. Please make sure patch file password is the same as the password for the current repository.

Step 6: Click Finish.

Cheers!

Bose