OBIEE Configuration Prerequisites

You can configure related content services to display Oracle Business Intelligence Enterprise Edition (OBIEE) analytics reports. The OBIEE servlet must be installed and OBIEE must be configured to enable OBIEE-based related content. In addition to configuring the analytics servlet, you must complete certain prerequisites before you assign OBIEE-based related content services to application pages.

When using OBIEE analytics as related content services, note the following configuration requirements:

  • The OBIEE database needs to be on release or later.

  • The PeopleSoft application database and the OBIEE database must be configured with the same users to access the reports.

  • XML needs to be generated for the OBIEE report definition that you make available as related content. To automatically generate the XML, navigate to the advanced tab on the OBIEE report definition and save the report.

  • The sizing of reports needs to be handled on the OBIEE database. The associated grid, width of the page, and centering of the objects cannot be adjusted.

  • Set up the Integration Broker Gateway on the PeopleSoft database.

  • Encrypt the secureFileKeystorePasswd.

    1. Select PeopleTools > Integration Broker > Configuration > Gateways and click the Gateway Setup Properties link.

    2. Enter administrator in the User ID field and password in the Password field and click the OK button.

    3. Click the Advanced Properties Page link and search for secureFileKeystorePasswd.

    4. Copy the password and encrypt it using the Password Encryption Utility at the bottom of the page.

    5. Replace the existing plain text password with the encrypted value.

    6. Click the OK button.

    7. Save the page and click the OK button.

  • Test the deployment by entering this URL in your browser: http://<webservername:port>/analytics.

  • After installing analytics.war, update the OBIEE server setup with the weblogic URI: http://<webservername:port>/analytics and reload the report definitions.