0 Replies Latest reply: Aug 16, 2012 4:01 AM by 836947 RSS

    Integrating OBI with OER


      For Reports Functionality, I need to integrate OBI with OER.

      But I am not able to do so.

      I have followed steps as

      a) Installed OBI..

      b) Unzipped BIP-Oracle.zip in folder bip\server\domains\bipdomain\servers\bipserver\tmp\XMLP folder

      c) modified xmlp-server-config.xml file under bip\server\wls\user_projects\applications\bipdomain\xmlpserver\WEB-INF as

      <?xml version = '1.0' encoding = 'UTF-8'?>
      <xmlpConfig xmlns="http://xmlns.oracle.com/oxp/xmlp">
      <file path="D:/BIPublisher/bip/server/domains/bipdomain/servers/bipserver/tmp/XMLP"/>
      <file path="${xdo.server.config.dir}/repository"/>

      d) After this setting, In BI Publisher console (http://localhost:7101/xmlpserver), I can see the OER folder under catalog/Shared Folders.

      e) I tried to login to BI Publisher console with OER user but it is not working. So I kept on using weblogic/welcome1

      f) After doing setup in BI, I did some settings in OER console under system settings for Reports.

      g) I did following settings

      cmee.reports.enabled = true
      oracle.reports.server.endpoint.url = http://localhost:7101/xmlpserver/OER/services/PublicReportService
      oracle.reports.server.username = weblogic
      oracle.reports.server.password = welcome1

      But even after doing this, under Reports tab in OER console, I am getting message as

      An error occurred logging into the report server. Incorrect credentials may have been submitted for the system settings Report Server Username and/or Report Server Password. Please correct this to enable automatic login to the report server or continue to run reports using manual login.

      I have followed the steps as per OER Configuration Guide.

      Please let me know if I have missed something. I am stuck here.