[OBIEE 10g] Multiple RPD's Online Simultaneously On The Same ORacle BI Server

 

Multiple RPD’s Online Simultaneously on the Same Oracle BI Server

Multiple OBI repository (RPD) files can be placed online simultaneously in a single OBI server so that each of them can be individually accessed through separate BI Presentation services.

1. Stop all the OBI Services (i.e. OBI Server, OBI Presentation Server and Java host).
2. Open the NQSConfig.ini file and add lines as shown in the screenshot.

i.e. Point to the default RPD (here paint) as Star and the other RPD (Guident) a Star1.

1. Now start the OBI services (i.e. OBI Server, OBI Presentation Server and Java host). The OBI server will point to the paint RPD as it has been marked as default.
2. Now we have to point to the Guident RPD from the Presentation service of another system. For this a DSN has to be created pointing to the BI server where the Guident RPD is residing.
3. Go to Control Panel–>Administrative Tools–>Data Sources (ODBC). Go to the System DSN tab and click on Add.
4. Create New Data Source window pops up, from the list of drivers displayed select Oracle BI Server and click on Finish.
5. The OBI Server DSN Configuration window will open. Enter a Name (TEST_DSN) for the DSN and the IP address of the system containing the OBI Server which is pointing to the Guident RPD and then click on Next.
6. In the next window select the checkbox Change the default repository to and enter the name of the RPD as Star1 and click on Next. In the next window click on Finish.
7. Now edit the instanceconfig.xml file and go to the DSN tag. Change the DSN from the default AnalyticsWeb to the DSN that has just been created (TEST_DSN).

1. Now start the BI Presentation Server and Java host on this machine. It will be pointing to the Guident repository.