OBIEE 11g Repository Merge New Development
- Create a Folder call it Merge. 
- Copy the Current Repository from Production and rename it to Current. 
- Create a Blank repository and call it Base. - Make a copy of the recently developed Repository and call it NewDevelopment. Only have the new development and nothing else in this repository.
 
- Open Current.rpd in offline mode.
- File > Merge then follow the below screenshot:
- Follow Next Screenshot (Define Merge Strategy): 
- Check Global Consistency “yes”. 
- Close the Consistency Check Warning Screen. Make sure there are no errors in the repository; if any errors fix the repository, warnings are okay to move forward. 
- Let the Merge complete. The merge might take about 15 mins or more. - After a couple of mins, you can close the repository and cancel the Merge. The merge has actually happened. Consider upgrading the client tool to the latest, check Oracle site. 
- Now in the Merge folder, there should be 4 repositories. 
 
- Rename the repository according to your standards and load it up for testing via the EM. 
