OBIEE Deployments – RPD & Catalog

This information is widely available on various blogs as well as on Oracle websites, but I thought I will rewrite the steps in my own language.

There are two kinds of deployments that we do as part of BI (Oracle Business Intelligence) deployments.

1. RPD

OBIEE repository database is also known as a RPD because of its file extension. The RPD file is password protected and you can only open or create RPD files using Oracle BI Administration tool.

RPD is created/modified using Oracle BI Administration tool.

obiee4

BI Admin tool needs ODBC datasources to be configured to connect to a BI server, see example.

obiee5.PNG

 

2. Catalog

This is a Presentation layer which provides a way to present customized views of a business model to users.

Subject areas in the Presentation layer appear as catalogs to client tools that use the Oracle BI Server as an ODBC data source.

Subject areas contain presentation tables, columns, hierarchies, and levels.

You can use OBIEE Catalog manager to make online as well as offline changes.

managing-catalogs-for-oracle-b-i-enterprise-edition
obiee3

Deploying RPD manually via enterprise manager (You can also deploy this using WLST)

Step 1:

Login to enterprise manager -> http://machine-1:7001/em

Step 2:

Once  logged into EM, Go to Business Intelligence on left side pane and select ‘coreapplication’.

Go to ‘Deployment’ tab -> select ‘Repository’ tab -> click on ‘Lock and Edit’ option.

obiee1

Step 3:

Once you click on ‘Lock and Edit Configuration’ you will get the confirmation message . Click ‘Close’.

Step 4:

Select rpd file you want to deploy for RPD deployment.

After you have browsed and selected the rpd enter the repository password.

Make sure you have copied and unarchived the catalog zip in the catalog location if you are deploying catalog as part of this deployment else just ignore catalog.

Click on ‘Apply’ button to save the changes and then Click ‘Activate Changes’

Step 5:

Once you click ‘Activate Changes’ , Activation process will start..

After this process is over, It will show the confirmation window. Just click ‘Close’

Step 6:

Once the change has been activated, It will ask for a restart saying ‘Restart to apply recent changes’. Click ‘Restart to apply changes’

Step 7:

Once you click ‘Restart to apply recent changes’. You can restart individual process layers separately or can restart all, just highlight the row of the process or server under it to stop/start/restart.

obiee2

Once the services have been successfully restarted, The repository will be updated. If there are issues, login to the server, check logs and use OPMN to stop/start services.