Business Intelligence – Oracle

Oracle BI EE – Merging Repositories – Substitute for Import From Repository – 2 way Merge with No Parent – Part 2

Posted by Venkatakrishnan J on March 24, 2008

If you look at the comments section of my blog entry here, there are quite a few users who have mentioned that the procedure did not work on their setup. One of the main reasons for that was that the changes being merged was not shown to the end user. Also, the procedure did not work for some of the earlier versions. So, i thought of blogging about another procedure that would basically merge only two repositories. If you had worked on the earlier releases of BI EE ( 7.8 or before versions ), you would have noticed that there was an option called Import from Repository. What this option basically did was it imported the objects from one repository into another. But this has been deprecated from version of BI EE. Now the recommended way of getting one repository objects into another is to do a 2-way merge. Lets look at a step-by-step approach for achieving this. So basically our aim is to combine the contents of 2 repositories into a 3rd repository. The merge process would look like the one shown below


So basically, our idea is to use a blank repository as the baseline repository. Now, in our example we shall be using 2 repositories. One repository would be the default paint repository. The other would be the default bise1 repository. As the first step open up the paint repository in offline mode.


Then click on Merge. Specify a blank repository (create a repository which has no objects) as the original repository.



Once this is done, select the bise1 repository as the Modified Repository.


You would basically find the list of presentation catalogs, users, groups etc. In your case you would find either of the 2 descriptions below

Add to Current

Delete from Current

When it is Add to Current, you can choose your decision as Current or Modified(D). If you choose current, the presentation catalog would be added to the repository. Else it would be deleted from the repository. Choose Current as the decision for all the “Added to Current” descriptions.


If you have Delete from Current, you would have to decide whether to add the objects to the repository or delete them. Now, click on merge. This should merge both your repositories properly.


13 Responses to “Oracle BI EE – Merging Repositories – Substitute for Import From Repository – 2 way Merge with No Parent – Part 2”

  1. […] Posted by Venkatakrishnan J on November 22, 2007 Update: Based on the comments below, i have created a new blog post which would work in all the scenarios. You can find it here.  […]

  2. […] by Venkatakrishnan J on March 28, 2008 As i have said here, the supported way to combine objects in 2 repositories is to use a 2-way merge without Parent. But […]

  3. Sofiane said

    Hi Venkatakrishnan,

    The merge process works but unfortunately it is redemunt because we cann’t use all the functionality of decisions based on all the repository object Type. (there is no object for variables, initialization blocks, etc.)
    In this case we have to manually delete the duplication after the merge, but it still the only way to mantain different version of an rpd file.


  4. Qinghe said


    If you try open paint.rpd in offline mode as the current repository, choose blank.rpd as the original repository, and then choose paintdummy.rpd ( a copy of paint.rpd) as the modified repository, the result I hope will be paint.rpd as paint.rpd = paintdummy.rpd. Actually it is not! The resulting repository
    contains duplicated physical layers, duplicated BMM and duplicated
    presentation layers!

    Best regards,

  5. Well written article, and I agree entirely. Thank you for your fresh point of view. Keep up the good work.

  6. […] that we can use to automate the merging of 2 web catalogs. If you had looked at my blog entry here, i would have shown you an approach to merge 2 repositories. That concept can also be applied for […]

  7. Mark said

    I agree with Qinghe. This method only works if I’m merging two completely different Presentation Layers. If I start with a “Global” presentation layer in my “Current” repository, and I’ve made some changes (let’s say I’ve added a couple of calculated columns), then when I go to merge my “Modified” global presentation layer into the “current” repository, the presentation layer is called “Global #1”, and all of the objects are duplicated.

    So… Method #1 doesn’t show us what changes will be merged. Method 2 only works for merging the contents from two completely different repositories.

    Is there a method that works every time in all circumstances?

  8. Sachin said

    Hi raghu,
    A very interesting thought process indeed.
    Very helpful.
    Do you have any experience in configuring a waterfall report using bar stacked chart view in Answers?
    If yes kindly shed some light on the useful approach.


    I need to configure a waterfall report using bar stacked view , given the condition that the bar for the next measure should start seperately from the upper limit of the previous measure and not 0 on the x axis.

    Any help in this regard is appreciated.

  9. Anitha said

    Hi Venkat,

    I’m new to BI and would appreciate if you could help me out with the following.
    I’m trying to merge two repositories, which are of considerable size and when I try to open the merged repository, it takes quite a bit of time to open the repo. When I open them indivually, it has acceptable performance. Are there any ways to tweak the time it takes to open the modified repo? What are the performance implications of merging two repositories of considerable size?


  10. […] Oracle BI EE – Merging Repositories – Substitute for Import From Repository – 2 way Merge… page_revision: 0, last_edited: 1241377750|%e %b %Y, %H:%M %Z (%O ago) edittags history files print site tools+ options edit sections append backlinks view source parent block rename delete help | terms of service | privacy | report a bug | flag as objectionable Hosted by — get your free wiki now! Unless stated otherwise Content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License Click here to edit contents of this page. Click here to toggle editing of individual sections of the page (if possible). Watch headings for an “edit” link when available. Append content without editing the whole page source. Check out how this page has evolved in the past. If you want to discuss contents of this page – this is the easiest way to do it. View and manage file attachments for this page. A few useful tools to manage this Site. See pages that link to and include this page. Change the name (also URL address, possibly the category) of the page. View wiki source for this page without editing. View/set parent page (used for creating breadcrumbs and structured layout). Notify administrators if there is objectionable content in this page. Something does not work as expected? Find out what you can do. General documentation and help section. Terms of Service – what you can, what you should not etc. Privacy Policy. _uff = false; _uacct = “UA-68540-5″; _udn=””; urchinTracker(); _qoptions={ qacct:”p-edL3gsnUjJzw-” }; […]

  11. Suren said

    How to use one OBIEE for another (Urgent Please)

    Hi Venkatakrishnan and everyone,

    We have 4 OBIEE instances on 4 different servers (prod, uat, qa and dev)

    We are planning to move dev to uat and lease off dev server.

    What are the steps required to move DEV to UAT.

    I am new to OBIEE and needs this to be done asap.



  12. Ven said


    I am trying to merge 7.9.3 BI Apps rpd(made few customizations on it) with that of 7.9.5 rpd .I am getting few duplicates while this is being done in the above approach.Can you suggest me further on this…

    With Regards

  13. Good post thanks

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: