Friday, July 12, 2013

OER (Oracle Enterprise Repository) Reporting Feature (BI Publisher)

Oracle Enterprise Repository (OER) provides total control and manageability of all your SOA assets and also tracing the relationships between various services, business processes and other assets in your enterprise.

By SOA governance through OER, you can gain greater visibility into your SOA assets, reduce redundancy, track usage, credit projects that reuse assets thereby promote reuse of the same - resulting in cost savings & better maintenance.

One of the core features of any SOA governance product is the support to render various reports;

In order to enable OER reports, you will need to have BI publisher installed which will augment detailed analytic & reporting capability to OER. Without this, OER reports screen will display the following message;

Please set the system setting for Report Server URL. Reports cannot be run until this has been properly set.

Once BI publisher is installed, perform the following configurations to enable OER reporting;

Configure BI Publisher with OER:

1. Stop BI Publisher server
2. In the OER server install, Extract the file [This zip file can be found under <OER_HOME>/core/tools/solutions/reports]
3. Copy "OER" folder from the "Oracle" folder (Assuming the install is on Oracle DB - else copy OER folder from appropriate DB folders that are supported) into the following BI publisher directory;


4. Start the BI Publisher server and verify whether the OER folder is shown under the "Shared Folders" by visiting the following URL;

Configure OER JDBC Data Source:

1. Login to BI Publisher as admin user (eg. weblogic)
2. Click on the "Administration" tab

3. Under the "Data Sources" section, choose "JDBC Connection"

4. Click on "OER" data source and ensure that BI Publisher can successfully connect to OER

Configuring the Reporting settings on OER:

1. Login to OER as admin user and click on "Admin" tab

2. Click on "System Settings" in the left admin panel

3. In the "Search" text box, type "report" - This will automatically filter the setting results and show only the "Reports" section

4. Ensure that the following properties are set properly

  • Enable Reports - True
  • Report Server URL - http://<hostname>:&lt:port>/xmlpserver/OER
  • Report Server Endpoint URL - http://<hostname>:&lt:port>/xmlpserver/services/PublicReportService
  • Report Server Username: admin (user to connect to BI Publisher server)
  • Report Server Password: password for admin user
5. Save the settings

Now, go back to the "Reports" page in OER and enjoy generating reports. There are many out-of-box reports that OER provides. You can also create custom reports in BI publisher and make them available in OER - That will be a topic for my next post :)

If you want to enable single sign-on between OER & BI Publisher, then you will have to create a OER user on BI Publisher server and assign the BI groups (OER_Reports) to this user. You will have to then configure this user under the OER reports section for seamless access.

No comments:

Post a Comment