How to MERGE Two Repository in OBIEE 11G | The Big Data - Business Intelligence by Sandeep Venu

Enter key word

How to MERGE Two Repository in OBIEE 11G

Hi All,
  1. Oracle Database
  2. OBIEE Server
  3. OBIEE RPD
  4. OBIEE Maps
  5. Weblogic
  6. Errors
  7. Upgrade
  8. Customize
  9. Patch

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.
  1. Oracle Database
  2. OBIEE Server
  3. OBIEE RPD
  4. OBIEE Maps
  5. Weblogic
  6. Errors
  7. Upgrade
  8. Customize
  9. Patch

Thanks,

Sandeep





SHARE

About test

    Blogger Comment
    Facebook Comment

7 comments:

SSS Blogs said...

HeLLo Im Nidhi

Can i get a COpy of obiee 11.1.3 Software SIte Information My Email ID :- Nidhi.sssbi@gmail.com

baby pooh said...
This comment has been removed by the author.
mehak kashish said...

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

Unknown said...

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

Ashvini said...

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.

keisy said...

Hi!,
How long it will take to run merging rpd...it's almost 1 hour and still Check Consistency and Check Navigation Space.

keisy said...
This comment has been removed by the author.

Top Links

Upgrading BI Publisher

Add Google Search

OBIEE- LDAP

Change Admin Password

Best Practices

ORACLE 11GR2

Host Files

Customization

OBIEE-SIEBEL

Bug Fixes

Setting Default

OBIEE Installation failed

OBIEE Installation

Oracle Databse

Oracle In Linux

Loopback Adapter

Weblogic Failed

Yum Commands

Weblogic Admin

Linux Static IP

OBIEE LDAP

Admin Paswword

Scaling

Weblogic Starting Error

Localizing BI

Physical Schemas

Multimedia Dashboard

Video in OBIEE

Variables in OBIEE

Ago 30 Days

Email Link

ODI Installation

AGO Function

Sort Pivote table

OBIEE Patch

Reset Sys password

Date Calculation

Add Row in Report

Increase Row limit

OBIEE with Essbase

Reset Weblogic

BIP Login Error

MDS and BI Platform

ORA 28001 Error

ORA 12560 TNS Protocal Error

ORA 12154 TNS Error

OBIEE ON AIX

Pre Requsite

AIX Commands

Commands