Overview
In this tutorial, you perform the process of integrating BI Publisher 10.1.3.4.1 with Workspace 11.1.2.
Prerequisites
Before starting this tutorial, install and configure Oracle BI Publisher 10.1.3.4.1, Hyperion Shared Services 11.1.1.3.00 (can be on same machine) and Foundation Services 11.1.2 on a separate machine.
Register Oracle BI Publisher 10.1.3.4.1 with Shared Services 11.1.1.3.00 and Enable Shared Services Security
Tip: If BI EE and BI Publisher are installed on the same machine, then integrate BI Publisher with Shared Services first. Otherwise the BI Publisher Admin Tab may not appear for the Administrator user.
1. | Log in to Oracle BI Publisher with Administrator credentials |
---|---|
2. | Selecting the Admin tab to navigate to the Oracle BI Publisher Administration page. |
3. | Under Integration, click the Hyperion Workspace and Shared Services link to launch the configuration page. |
4. | In the Database Connection for Hyperion Workspace section, enter the Hyperion Home location where the reg.properties file is located. Note that you must enter only the Hyperion Home location, not the full path to the reg.properties file. |
5. | Click Load Properties. This will populate the following fields based on the values in the reg.properties file that you pointed to in the previous step:
|
6. | The fields in the Hyperion Workspace Registration region are defaulted from the servlet context. You can update these fields if you want to run BI Publisher in both SSL and non-SSL modes; or if you are using a load balancer, enter the server information for the load balancer. |
7. | In the Hyperion Shared Services Registration region. perform the following tasks: 1. Enter data into the following fields that describe your Shared Services 11.1.1.3.00 installation:
|
8. | Click Register.A confirmation message is displayed. |
9. | Restart your BI Publisher server application for these changes to take effect. |
10. | Provision BI Publisher Administrator via Hyperion Shared Services 11.1.1.3.00 |
Importing BI Publisher data into the EPM System 11.1.2 Registry
1. | On the machine where Foundation Services 11.1.2 is installed copy the following template, bip.xml from EPM_ORACLE_HOME/common/config/11.1.2.0/resources/bi/ toMIDDLEWARE_HOME/user_projects/epmsystem1/temp NOTE: the temp directory needs to be created under epmsystem1. |
---|---|
2. | Edit the template bip.xml with the relevant host name and port numbers for your BI Publisher 10.1.3.4.1 installation. |
3. | From MIDDLEWARE_HOME/user_projects/epmsystem1/bin/ run the following .bat (.sh) file::
epmsys_registry.bat createcomponenthierarchy ../temp/bip.xml
|
4. | Run EPM System Configurator and configure the Web Server again. (On the Task Selection page, select the Foundation Services Web Server Configuration task.) |
5. | Restart the Foundation Services, the Web server, and the Web Application. |
6. | Login to EPM Workspace with a valid username and password. |
7. | Click Navigate > Applications to view BI Publisher menu. |
Summary
In this tutorial, you have learned how to integrate BI Publisher 10.1.3.4.1 with Workspace 11.1.2.