OBIEE - Merge Repository (SCM)

Bi Server Architecture With Client


The Oracle BI repository development process adheres utilizes a three-way merge to manage concurrent development.

Obiee Repository Merge Menu

The merge process involves three repositories:

  1. The (Original|Received|Master|Parent) repository. The repository that you received before changed. You must keep it preciously unchanged.
  2. The Modified repository. The repository that contains the customizations you made to the original repository.
  3. The Current repository. Generally, the repository that is in production and where some customisations could have been performed by other people.

In a multiuser environment (MUDE), Developers check out the file and make changes locally. Then, these changes are automatically reconciled and merged into the master repository.

Since 11g, you have two options:

  • a patch merge type
  • equalize. Equalizing before merging repositories prevents unintended renaming during the merge.

The article below explains how to merge manually (ie outside of the MUDE) in a full repository merge mode.

Obiee 11g Merge Repository

Type of merge

Two scenarios exists:

Type of merge Common Parent / Original Repository present ? Description
two-way No Import objects from different repositories
three-way Yes Promotion Merge from one environment to another of a MUDE merge

With no common parent, Conflicting object (object with the same name in the two repository) are treated as different. They are duplicated while merging or importing. A suffix #n is appended (where #n is a variable number).


The merge process involves three steps :

  • Comparison between the Current repository and the Original Repository to find out your modifications
  • Reconciliation (if necessary). You must decide which modifications occurs if the merge process is unable to find a solution between your modifications and other modifications.
  • Merge. The last step where you just start the merge action.


You must open the Current Repository, then choose from the menu File/Merge. Locate and select the original repository, the merge process must show you a list of all differences. (It perform a comparison).

If the two repository are identical, it's not needed to continue the process. You're merge file is your modified repository.
Obiee Repository Merge Identique


You must now select the modified file. The merge program search some possibles conflicts.

No Conflict

If you don't see any conflicts in the center table of the windows, you can click the stats button to view an overview of the merge decisions that will take place.

Obiee Repository Merge Without Conflict

With Conflict: Decision

If some conflicts appear, you must choose an action between :

  • Current. This type has no suffix. Selecting this type means that you want to leave the object in the current repository as is).
  • Modified. This type can have an A (add), a D (delete), or an AR (after renaming) suffix.

AR means that the Modified version will be accepted but because it conflicts with another name in the repository, it will be renamed. For example, if both the Current and Modified repositories add the same object with the same name and the user chooses to accept both versions, both would be added and the object from the Modified repository would be renamed.

  • Mix. The object was not added or deleted but at least one of its properties was modified. For example, you can select the choices for the properties.

In the example below, the name from a logical table have been modified in the modified repository and in the current repository. So, you must choose which one is the correct name.

Obiee Repository Merge Reconciliation

Examples of the Results of Some Decision Choices

The following examples show the results of some decision choices when the current and modified repositories are different:

Description column Your Decision The Result
Added to Current Current keeps the addition in the current repository
Added to Current Modified (D) deletes the added object from the current repository
Deleted from Modified Current keeps the repository as is without deleting the object
Deleted from Modified Modified (D) deletes the object from the current repository
Deleted from Current Current keeps the repository as is without adding the object back into the current repository
Deleted from Current Modified (A) adds the object back into the current repository
Added to Modified Current keeps the repository as is without adding the object back into the current repository
Added to Modified Modified (A) adds the object back into the current repository


When you have answered to all decision, you can click on the Merge button to merge the modified repository and the current repository in an other repository.

You can see the merge log file in the same directory than the current repository. For instance : Current_sh.merge_log.csv


Delete Failed

When you do an merge, you may get this error: “Delete Failed”. You may have objects with the same name. An equalize may correct the problem.


Discover More
Obiee Bi Server Patch
OBIEE - BI Server Patch (automatic update with a patch file)

An alternate way of updating the RPD manually is to script it with an XML patch file. In this approach, you don‟t need to open the RPD through an Admin tool. Instead, the values of the variables...
Obiee Repository Options Mud
OBIEE - MultiUser Development Environment (MUDE - Projects)

By default, the Oracle BI repository development environment is not set up for multiple users. However, online editing makes it possible for multiple developers to work simultaneously, though this may...
Obiee Repository Merge Manuel
OBIEE - Objects Import from another repository

To import a repository in an existent repository, you have two options : made a Two-way merge with a dummy repository as parent use the deprecated feature import. Without parent, you can still...
Obiee 10g Equalize
OBIEE 10G/11G - Equalizing Objects

The Oracle BI Server assumes that two objects with the same name but two different upgrade ids (or Id) are two different objects. Equalizing objects causes objects in two repositories that have the same...
Obiee Online Offline
OBIEE 10G/11G - Repository (RPD file)

The repository is the file that contain all metadata of the BI Server and is managed through the administration tool. It stores all the informations the application environment: the security, data...

Share this page:
Follow us:
Task Runner