In OBIEE 10g the current running rpd and catalog files are configured in two files called NQSConfig.ini and instanceconfig.xml respectively. So If we want to change the current running rpd and catalog in OBIEE 10g we are opening the file and we are changing the rpd name and catalog name into these files. But in OBIEE 11g these things are controlled by Enterprise Manager (EM).
Locations of Repository and Catalog in BI 11g:
We can get the rpd and catalog which we have developed from below folders.
RPD Location Path:
Catalog Location Path:
Login into EM entering link like below in your browser address bar:
Once we logged into EM, Go to Business Intelligence from left side pane and select 'core application'. Select repository from right side pane.
Go to 'Deployment' tab -> select 'Repository' tab -> click on 'Lock and Edit' option.
We are getting the below screen and the number shows
1. It tells the current running repository
2. This says the current running catalog
3. 'Lock and Edit Configuration' enables the Screen to change the repository
Once we clicked 'Lock and Edit Configuration' we will get the confirmation message like below screen. Click 'Close' with the screen.
So In the next screen we are having the options to select repository and catalog which we want to deploy. After you selected the rpd and catalog click apply and click Activate Changes. The screenshot is like below:
The number indicates in the images are:
1. The place to choose the repository
2. The place to change the catalog
3. 'Apply' button after modification
4. 'Activate Changes' to change the rpd and catalog
5. 'Release Configuration' Which revert the page to old state
Choose the repository from the location and enter the repository password and change the catalog name which we need to change.
Note: Do not forget to click 'Apply' button to save the changes and after that Click 'Activate Changes'
Once we clicked 'Activate Changes' with the above screen , Activation process will be started and it will show the below screen.
After process is over, It will show the confirmation window like below screen. Just click 'Close'
Once the changes has been activated, It will ask for the 'Restart to apply recent changes'. Click 'Restart to apply changes'
Once we Clicked 'Restart to apply recent changes' It will come to the below screen. Click 'Restart' to restart all the BI Services. Once the services is successfully restarted The repository and catalog is updated.Now open Administration Tool and Presentation Services to check the changes.
Deploying RPD and Catalog in OBIEE 10g:
Deploying repository and catalog in 10g is very simple than 11g.
To deploy repository:
Go to the path Drive:
After we changed the repository name in INI file, we need to Restart the 'Oracle BI Server' Service.
Go the path Drive:
After we changed the name in the xml file, we need to restart the 'Oracle BI Presentation server' Service.
Now Login into Administration Tool and Presentation Services to check the changes.