Embedded Files
Post date: 23-Apr-2010 07:48:10
One of the issues with the Oracle BI environment is how to create multiple presentation services. One of the reason why customers want this is for installing one machine with multiple environments ie. DEV en ACC. The documentation of the OBIEE suite is mentions that the above question can be done, but not in detail!
This article shows in detail how to create multiple OBIEE presentation environments on a Windows machine. The steps we have to do for creating a second (or more) presentation services are the following:
1.- Deploy a new version of de application analytics;
2. - Create a new catalog;
3. - Change/create configuration files;
4. - Create startup files.
Ad 1
Deploying a new instance of the analytics application can be done from the Entripise Manager (http://server_name:9704/em).
1. - Click on the deploy button and choose the correct archive.
2. - Click on next (step 2 - applicaton attributes) and a new deployment plan will be created. Now you are on the second step and you can enter a new application name. In this case I call the application analytics_test. Also change the context_root into analytics_test.
3. - Click again on the next-button (step 3 - deployment settings), leave all the values as is and click on the deploy button.
After these three steps the new presentation service (analytics_test) is available. For this presentation service we want to create a new catalog.
Ad 2
Copying the original catalog into another directory is how to create the new catalog. Copy the directory OracleBIData\web\catalog to OracleBIData\web\catalog_test. Now the new catalog-directory is ready to use and should be entered in the configuration file ( instanceconfig.xml).
Ad 3
Now we have created the new presentation service and the catalog for this service we have to change/create the configuration files. The default configuration file (instanceconfig.xml) tells us which listener-port, catalog and which presentation service will be used.
1. - Make a copy of the original instanceconfig.xml en name this file instanceconfig_9710.xml. Also make a second copy of the original file and name this file instanceconfig_9712.xml
2. - Set the DSN to the correct repository. In this example I use the repository paint with DSN-name analyticsweb_paint. Change the default repository to paint.rpd.
3. - Change the listener port in file instanceconfig_9710.xml into 9710. Also change the listener port in file instanceconfig_9712.xml into 9712.
4. - Change the catalogpath in instanceconfig_9710.xml into %SADATADIR%/web/catalog/paint. Also change the catalogpath in instanceconfig_9712.xml into
%SADATADIR%/web/catalog_test/paint.
5. - Edit %SAROOTDIR%\oc4j_bi\j2ee\home\applications\analytics_test\analytics\WEB-INF\web.xml file to make this deployment point to another instance of your presentation service. Search fororacle.bi.presentation.sawserver.port and change the param-value into 9712.
After creating the new configuration files we can start the presentation services.
Ad 4
To start the new presentation services we create two shortcuts. These shortcuts have the targets:
- sawserver.exe -c %SADATADIR%\web\config\instanceconfig_9710.xml
- sawserver.exe -c %SADATADIR%\web\config\instanceconfig_9712.xml
Starting the instances opens a DOS-box with a running presentation service. After the presentation services are started we can login and type the following url in your webbrowser:
Both the presentation services refere to one repository file (paint.rpd) but you now have the ability to create different reports, dashboards etc in different presentation services.
Ref: http://bvellinger.blogspot.com/2008/01/obiee-10132-and-multiple-presentation.html
Page updated
Google Sites
Report abuse