Merging OBIEE Repositories
One will definitely come across requirement where he/she needs to merge two repository.
There will happens when we need to merger two entirely different repository or when we want to move incremental changes to production.
OBIEE does support 2 online repository ( However you can have 2 repository online but by doing so one will lose the oracle’s product support). In this case merging two repositories into one and making it online is the solution!
Let me discuss that aspect first.
We will two standard repositories paint.rpd with UsageTracking.rpd so that we can get the usage information in paint repository.
Steps 1 Background
You can mergr two repository in one ,when one is online. However I would not suggest you to do that.
Make sure while merging you are working offline in Administrator tool.
Merging originally designed to work with three repositories. As we have just two repositories we will create a dummy repository.
Go to Administration — > File — > New and create a new repository call dummy.rpd
Creating Dummy.rpd
( Save this to this default location <Home>\ OracleBI\server\Repository however this is not necessary)
Now close this repository with doing anything. Just save when prompted.
Step 2 Open the paint.rpd in offline
Open pain.rpd
paint.rpd
Step 3 Merger paint.rpd with dummy.rpd
Go to File — > Merge and select dummy.rpd
open dummy.rpd for Merge
You will see the screen as below:
Merge Screen
step 4 Click select for the Modified Repository and select UsageTracking.rpd
Selecct usage tracking for merging
In decision you can either select Modified or Current. As we are merging 2 different repository it ok. select merge. You will see an error message called : Delete Failed. Just ignore that message.
And you will see both the repository merged as below.
Merged Repository Paint and UsageTracking
6 Responses to “Merging OBIEE Repositories”
Pingback from Usage Tracking in OBIEE » All About OBIEE and DAC
Time December 2, 2011 at 2:05 am
[...] Step1 : Merge usage tracking rpd with existing rpd Merge usage tracking rpd with existing rpd [...]
Comment from bala kishore
Time December 13, 2011 at 11:54 pm
thanks a lot for this topic it given fully information of usage traking
Comment from Dhwani Shah
Time December 14, 2011 at 11:12 pm
Thanks Bala for your comment
Comment from Siva Reddy
Time December 29, 2011 at 1:13 pm
after merging of rpd’s what to do next.
Comment from Dhwani Shah
Time January 6, 2012 at 12:20 pm
It depends on what you want to achieve. or which rpd and web cat you want to merge.
Common thing is- after merging you can have single rpd and web cat and have everything in one place.
Comment from Drip Tray %0B
Time January 29, 2011 at 5:43 pm
;.; I am really thankful to this topic because it really gives great information -’;