Oracle BI - Multiple RPDs on single OBI Server

Loading multiple RPD on a single OBI server is very easy. But there is an extra requirement to access multiple RPDs.



You need as many presentation servers as number of RPDs loaded into OBI server. That means if you load 2 RPDs into the OBI Server, you will need two Presentation Servers and DSNs pointing to that OBI Server to access both RPDs.

• OBI Server Configuration
• Analytics DSN Configuration

OBI Server Configuration:
Open NQSConfig.INI from \server\Config\ (Normally SAROOTDIR=C:\OracleBI in windows and /OracleBI/ for Unix)


You will find Start = samplesales.rpd,DEFAULT;
Add one more RPD. Star2 = paint.rpd;


Now restart OBI Server.

DEFAULT keyword in NQSConfig.INI specifies DEFAULT loaded and presented RPD. Default loaded RPD is samplesales.rpd. So when you login to Oracle BI, samplesales.rpd will be available to you for querying.



Now we have to change the default RPD (Star) to Star2. That we can do by modifying DSN Entry.

Go to Control Panel\Administrative Tools and open "Data Sources (ODBC)" OR type "odbcad32" in Run dialog box.

Go to System DSN tab. Select AnalyticsWeb DSN and click "Configure...".

Click Next on first dialog box, leaving all setting as it is.

Enter Login ID and password. Check "Change the default repository to" and enter "Star2" in the text box below. Click next and then Finish.



Now restart Oracle BI Presentation service. You will see second rpd in your Answers.


You can also access two RPDs on the same matching by creating two Oracle BI Presentation Service.