Here are the simple steps to merge two repository in obiee 11g
You should have three rpd's for merging
1) Your Current RPD. (BISAMPLE.rpd) >>Current RPD<<
2) The RPD to be merged (the one you newly worked on) - sandeep.rpd >>Modified RPD<<
3) Dummy RPD. In My case dymmy.rpd
If you don't have a dummy. rpd , create a new rpd from the admintools (do not import metadata).
ok now we are all set to start the merging.
Step 1: Open your Current RPD, ie BISAMPLE.rpd in my case and select the merge option.
Step 2: Provide the details of RPD as given below.
Select dummy.rpd as your original rpd and Sandeep.rpd as the modified rpd
and click next >>
Step 3: Define Merge Strategy
In this case select Decision = Current
Click next finish >>>
The repository merge is now complete.
Open the BISAMPLE0009 (1).rpd (your target rpd) and reset the connection pools accordingly.
Thanks,
Sandeep
7 comments:
HeLLo Im Nidhi
Can i get a COpy of obiee 11.1.3 Software SIte Information My Email ID :- Nidhi.sssbi@gmail.com
too good piece of information, bangalore,i have read atleast 11 posts of yours by now, and let me tell you, your web-page gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new post, once again hats off to you! Thanks a lot once again, Regards, obiee training in hyderebad
Hi,
this was really a useful guide. By the way i have a question.
I have made a merge between two repositories one from 11.1.1.6.5 and the other from 11.1.1.7. I had opened the new repository withe the admin tools version 11.1.1.7.0 i saved it and i didn't receive any error. If i put this repository online, i receive a log in error when i try to log in.
Any suggestion?
Regards,
Marco
Hi,
I am getting an error [nQSError: 28006] Near Line 1, <"slc01mex">: Not defined. when I am trying to patch my rpd.
Applying /rpdSnippet.txt to /src/sampleapplite_bi0001.rpd outputting to temp/sampleapplite_bi0001.rpd
where as rpdSnippet.txt contains
DECLARE CONNECTION POOL "slc01mex"."DBUSERPOP" AS "DBUSERPOP" UPGRADE ID '8c332330-0c18-1000-9fee-0aa7646e0000'
DATA SOURCE '{(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=slc01mex.us.oracle.com)(PORT=14600))(CONNECT_DATA =(SERVER=DEDICATED)(SERVICE_NAME=db4847)(SID=db4847)))}'
TIME OUT 300
MAX CONNECTIONS 10
TYPE 'Default'
USER ''
AES_PASSWORD 'bi.connpool.user.pwd'
SHARED LOGIN
CONNECTIONS TO SAME URI 10
OUTPUT TYPE XML
BULK INSERT BUFFER SIZE 131072 TRANSACTION BOUNDARY 1000
TEMP TABLE PREFIX {TT} OWNER {}
PRIVILEGES ( READ);
Any help is much appreciated.
Hi!,
How long it will take to run merging rpd...it's almost 1 hour and still Check Consistency and Check Navigation Space.
Post a Comment