Configuring BI Publisher with EPM Workspace

  To configure BI Publisher with EPM Workspace:

1. Register BI Publisher with Shared Services Registry:

   1. Log in to BI Publisher with Administrator rights.

   2. Navigate to the BI Publisher Administration page by selecting the Administrator tab.

   3. In Integration, click the EPM Workspace and Shared Services link to launch the configuration page.

   4. In Database Connection for EPM Workspace, enter the Hyperion home location where reg.properties is located. (You must enter only the location of the Hyperion Home, not the full path to the reg.properties file.)

      For example: C:\Programs\Oracle\Hyperion

      The reg.properties file must be located on the same computer as the BI Publisher server application. See the “Prerequisites for Integration with EPM Workspace” section in the Oracle Business Intelligence Publisher Administrator's and Developer's Guide.

   5. Click Load Properties. Doing so populates the following text boxes based on the values of reg.properties that you pointed to in step step 1.d:

      • JDBC Connection String

      • Database Username

      • Database Driver Class

   6. The text boxes in the EPM Workspace Registration region are defaulted from the servlet context. To run BI Publisher in both SSL and non-SSL modes, update these text boxes; or, if you are using a load balancer, enter the server information for the load balancer:

      • BI Publisher Port

      • BI Publisher SSL Port

      • BI Publisher URL

      • BI Publisher SSL URL

      • EPM Workspace Application Server Type: Oracle Application Server 10g

   7. In the Shared Services Registry Shared Services box, enter the following text boxes that describe the Shared Services installation:

      • Shared Services Server: Name of the computer where the Shared Services server is installed.

      • Shared Services Port: Shared Services server port number on which the database listens.

      • Shared Services Administrator User name and password: The name of the database user.

        Caution!

        You must provision the Shared Services Administrator that you specify here with the BI Publisher Administrator role. Perform this step as part of Provision Users in the EPM Workspace procedure. See “Provision Users in EPM Workspace” in the Oracle Business Intelligence Publisher Administrator's and Developer's Guide.

      • Select Use Hyperion CSS Security Model upon registration.

        Doing so automatically changes BI Publisher's security model to the Hyperion Common Shared Services security model upon restart. The change also is reflected on the BI Publisher Security Configuration page. Integration with EPM Workspace requires using the Hyperion Common Shared Services security model.

        Caution!

        Before making changes that affect security, ensure that you have set up a BI Publisher Local Superuser to ensure access to BI Publisher regardless of your selected security configuration. See Defining a Local Superuser.

        Note:

        If you do not select the check box here, you can manually change the security model from the BI Publisher Security Configuration page after successfully registering and restarting the BI Publisher server application. If you did not complete the registration, the Hyperion Common Shared Services selection will not be available from the BI Publisher Security Configuration page. Performing this step manually requires an additional restart of the BI Publisher server to make the changes to the Security Configuration page effective.

2. Click Register.

3. Restart the BI Publisher server application.