Register Oracle BI Presentation Services Components with Shared Services

  Register Oracle BI Presentation Services Components with the Shared Services Registry:

1. Log in to Oracle BI EE.

2. Select Settings, and then Administration.

3. Click Manage EPM Workspace Connection.

4. Enter or edit the following data:

   • Oracle BI Presentation Services Host: Host machine for the current instance of Oracle Business Intelligence. You can specify the host name of another Oracle Business Intelligence instance that you want to integrate with EPM Workspace.

   • Port: Non-Secure Sockets Layer port number for this instance of Oracle Business Intelligence.

   • In SSL Port: Secure Sockets Layer port number for Oracle Business Intelligence.

     To use the Secure Sockets Layer port rather than the non-Secure Sockets Layer port, select Enable SSL beside the SSL port number.

   • Context Path: The virtual path that follows the host name in the URL for Oracle Business Intelligence. For example, if the URL is the following: http://myserver.com/analytics, then the Context Path is analytics.

     Select Application Server Type.

   • Description: Connection description. This description is not displayed elsewhere in Oracle Business Intelligence or in EPM Workspace.

   • Registry Properties File: Select one of the following values to indicate which Registry Properties file to use:

     • Installed Hyperion Home: If the computer on which this instance of Oracle Business Intelligence is installed also contains an EPM Workspace installation, then the HYPERION_HOME environment variable is already defined. The Registry Properties file for that Hyperion instance will be used (default setting)..

     • Generate File: The following text boxes are displayed:

       • JDBC URL: Enter the URL to connect to the Shared Services Registry database. If you are copying the JDBC URL from an existing Registry Properties file, then ensure that you remove the “\” character in the string. The “\” character is used to escape certain special characters.

       • JDBC Driver: Enter the driver to connect to the Shared Services Registry database.

       • User name: Enter the user name to connect to the Shared Services Registry database.

       • Password: Enter the password to connect to the Shared Services Registry database.

     For more information on these parameters, see the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide

   • Copy File: When you select to copy an existing Registry Properties file, the Source File Path text box is displayed. Enter the absolute path of the file that you want to copy. The Registry Properties file is named reg.properites. If you copy or generate reg.properites, it is located in the following directory:OracleBIData/web/hyperion/common/config/9.5.0.0.

     At any time in the process before you click Register, click Finished to cancel the registration process and return to the previous page.

5. Click Register to begin the registration process, which might take several minutes. You will see status messages and error messages displayed above the Register.

6. Log out of both Oracle Business Intelligence and EPM Workspace and back in to ensure that all changes have taken effect.