Old topic but still documenting it for my friends who are new to OBIEE.
These are the steps to implement multiple RPD and multiple presentation services on Single BI Server.
1. Change the NQSConfig.ini file as follows:
#################################################################################### [ REPOSITORY ]
RPD1 = samplesales.rpd, DEFAULT;
RPD2 = paint.rpd; ####################################################################################
2. There has to be two System DSN pointing to two different rpd.
AnalyticsWeb which is the default one. Change the default repository to RPD1 as shown in the below screenshot.
AnalyticsWeb_Test should be the new one. You can give any name.
Change the default repository to RPD2 as shown below.
So, the two DSN should be present in System DSN as follows.
3. Make sure two Catalogs samplesales and paint are present in C:\OracleBIData\web\catalog folder.
4. There has to be two instanceconfig file pointing to two different catalog and DSN.
Make a copy of instanceconfig.ini and name it as instanceconfig_test.ini
In the instanceconfig_test.ini file, add the listener port,change the system dsn and point it to paint catalog. Assuming the 1st config file points to samplesales catalog.
5. Deploy a new presentation server instance
Login to Enterprise Manager.
Username: oc4jadmin
Password: Password you gave while installing OBIEE.
Go to Application tab and click on Deploy.
Select the analytics.ear file from the following location and click next.
Give the application name as follows and click next:
In the next screen, click deploy. And you will get a successful confirmation page.
6. In the web.xml file of analytics_test application present under C:\OracleBI\oc4j_bi\j2ee\home\applications\analytics_test\analytics\WEB-INF folder,
modify the port as follows:
<param-name>oracle.bi.presentation.sawserver.Port</param-name> <param-value>9712</param-value>
7. Create a new presentation service from the command prompt.
Go to Registry Editor > HKEY_LOCAL_MACHINE>SYSTEM> CurrentControlSet>Services>sawsvc2 and update the image path as follows
“C:\OracleBI\web\bin\sawserver.exe” /service /c c:\OracleBIData\web\config\instanceconfig_Test.xml
A new Presentation Services “Oracle BI Presentation Server 2″ will be listed in the windows services as follows:
Restart all the services and OC4J.
That’s all and you can use these URLs for your two presentation services.
http://localhost:9704/analytics/saw.dll?Dashboard
http://localhost:9704/analytics_test/saw.dll?Dashboard
Thank you. Please let me know if you find any difficulty.
Go to Source
