[OBIEE 10g] Merge Two Different RPDs And Web Catalogs

OBIEE 10g Merge two different RPDs and Web Catalogs

To Merge the RPDs in offline mode.

Go to Admin Tool and create a dummy RPD (KPIT_OBIEE_Demo.rpd) save and close.
Open the 1st RPD (Sample Sales.rpd) which you want to merge with another RPD (sh.RPD)

Click on file and merge

Select the dummy RPD (KPIT_OBIEE_Demo.RPD), provide the user and password.

Click select for the Modified Repository and select 2nd RPD (sh.rpd)

In decision you can either select Modified or Current.

You will see both the repositories merged into one as below.

Merge Web Catalog Reports into New web catalog

Create a folder in OracleBIDataWebCatalog as SampleSales_SH

Add this folder name in the instanceconfi.xml file

Save and run the services. Oracle BI Presentation server will create default sub folders.

Merge the Sample Sales and SH web catalogs into SampleSales_SH.

Stop the services, so we can merge the web catalogs in offline mode.

Open two web catalog mangers (one old and another new) and copy respective folders from old to the new web catalog folder. Copy from both the old web catalog folders to new web catalog folder

Add the new RPD file name in the NQconfig.INI and run both the services.

You should get the new Web Catalog running on Interactive Dashboard.