Deploy RPD using Enterprise Manager in OBIEE 11g

This is the most common step while doing deployments. With Enterprise Manager coming into picture OBIEE has become more easier to handle. There are couple of ways of deploying RPD.

1. Direct replace of RPD in repository folder
2. Upload RPD using Enterprise Manager

We can follow both the ways but only based on the situation.Lets see an example to understand the same.

Consider we have a RPD named "OracleBIApps_001.rpd" and this needs to be uploaded to BI server.

Scenario1: The RPD that is currently loaded is also having the same name "OracleBIApps_001.rpd"

   This case we can follow the Method1 that is direct replace.Lets see the step of how to do it.

•   Stop the BI services (see here to start and stop services)
•   Go to the below folder

                 [ORACLE_HOME]\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository

•  Replace the existing RPD file with new RPD file
• Start the BI services
• Open the RPD in online mode and verify the changes

 Scenario2: The RPD that is currently loaded is having name different to the new one.

This is the real time scenario that we face everyday in our day to day code migrations.Here we have 2 options of doing the migration

1. Change the new RPD name as per the Existing RPD name and follow Method1.
2. Keep the name and upload using EM.

Since we already knew how Method1 works lets now see the Method2.

• Login to EM as weblogic
• Navigate to below screen

                   Business Intelligence - Coreapplication - Deployment - Repository

• Lock and Edit as shown below
  

•  Upload the new RPD using "Browse" and click "Apply".

 We could even change the catalog location if you wish to.

• "Activate Changes" and restart the server as shown below.

 

• Open the RPD online to verify the changes.

  Note: Don't perform the above step by changing the RPD name directly in NQSCONFIG.INI as any changes to config files which are not done through EM will revert back to default values when we bounce the services.