4 Reports

Oracle Real-Time Integration Business Insight application provides a few reports by default. the application also provides the ability to configure custom reports. However, the Reports functionality is available only for users with certain role permissions.

Only a user with role permission of InsightAdministrator can configure the reports in Oracle Real-Time Integration Business Insight application. Users with InsightExecutive and InsightModelCreator privileges can only view the reports.

If the reports are not configured, you see the following error message on the Reports page.

Figure 4-1 Reports Not Configured

Description of "Figure 4-1 Reports Not Configured"

Configuring Reports

You must configure the reports for them to appear in the application. Only a user with role permission of InsightAdministrator can configure the reports.

To configure reports:

1. Install BI Publisher 11.1.1.7 and apply patch set 5.
2. Apply the Oracle Automated Release Updates (ARU) patch to BI Publisher.
   This patch is required for the graphs to render when viewing HTML reports.
3. Log in to BI Publisher as a user with administrative permissions. The URL for BI Publisher looks like: The URL for BI Publisher is of the format: http://<hostname>:<port>/xmlpserver/ and the default port is 9704.
4. Navigate to Administration > Runtime Configuration > Properties.
5. Enable the following flags under HTML section.
   1. Embed images and charts in HTML for offline viewing: True.
   2. Use SVG for charts: True.
6. Navigate to Administration > Data Sources > JDBC Connection.
   1. Click Add Data Source and enter the following values:

      • Data Source Name: Insight

      • Driver Type: Oracle 11g.

      • Database Driver Class: oracle.jdbc.OracleDriver

      • Connection String: jdbc:oracle:thin:@<hostname>:<port>:<sid>

      • User name: <RCU_PREFIX>_soainfra

      • Password: password specified in RCU when creating users.

   2. Add a Clarifier with the following values:

      • values: the username and password for schemas created by RCU during installation

        A clarifier is essential as RCU will be run for BI Publisher and any SOA or OSB that Insight integrates to.

   A database connection to the Insight database in BI Publisher is created.
7. Click Create BI Publisher Users to create users with appropriate permissions to create and configure reports in Insight. For more information, see Adding Users/Groups to Pre-defined Roles.
8. Click Upload to upload the default Insight reports in the BI Publisher.
   1. Download the file soa/reports/Oracle_Integration_Insight_Reports.xdrz from the ORACLE_HOME on the WebLogic server.
   2. Navigate to Catalog.
   3. Click Shared Folder.
   4. Click Upload Resource and upload the Oracle_Integration_Insight_Reports.xdrz file (the file you downloaded in step a).
      A Catalog folder within Shared Folders/Oracle Integration Insight Reports is created.
9. Enter the user credentials for the BI Publisher users.

   1. Navigate to Security > Credentials in the Enterprise Manager Fusion Manager Control.

      Figure 4-2 Enterprise Manager Fusion Middleware Control Credentials Screen

      
      Description of "Figure 4-2 Enterprise Manager Fusion Middleware Control Credentials Screen"

   2. Expand oracle.soa.insight and select INSIGHT_BIP_CONNECTION_KEY. If oracle.soa.insight does not exist, click Create Map to create it, and then create the key INSIGHT_BIP_CONNECTION_KEY using Create Key.

   3. Click Edit to enter or edit the user name and password. These credentials are for the BI Publisher.

      The Edit Key Dialog opens. Enter the following details:

      Figure 4-3 Edit Key Dialog

      
      Description of "Figure 4-3 Edit Key Dialog"

      1. User Name: enter the user name you want to use to log in to BI Publisher. This is a mandatory field.

      2. Password: enter a password to log in to BI Publisher. This is a mandatory field.

      3. Confirm Password: re-enter the password you entered in the above step. This is a mandatory field.

      4. Description: enter a suitable description for the key. This is an optional field.

      5. Click OK.

10. Navigate to the InsightConfigBean in System MBean Browser.

    Figure 4-4 ConfigMBean:InsightConfigBean

    
    Description of "Figure 4-4 ConfigMBean:InsightConfigBean"

    The BiUserServerName field is unused and the BiServerPassword contains INSIGHT_BIP_CONNECTION_KEY, which is the default value.

11. Create a connection to the BI Publisher server by updating the MBean in Insight.
    1. Login to Oracle Enterprise Manager Fusion Middleware Control console in the Insight domain.
    2. Navigate to WebLogic Domain > System MBean Browser
    3. Open MBean Browser.
    4. Expand the InsightConfigBean. The attributes are:

       • BiServerPassword — The CSF Password Credential Key for the BI Publisher Server. The key should be INSIGHT_BIP_CONNECTION_KEY as created in the Credential Store.

       • BiServerUrl — URL of the BI Publisher Server. Enter a value similar to http://<host:port>/. Do not forget to include the port number in the URL. The integration automatically appends xmlpserver/ to the end of this URL. Hence, only the protocol, host, and port are included.

       • BiServerUsername — this attribute is not used.

The Reports are configured.

The configuration must be validated by logging in to the Insight application. You see reports when you navigate to Reports. The reports start generating the data when you have created and activated models in the application.

Understanding Reports

Each of the default reports is meant for a specific purpose and displays certain data.

When the administrator configures the reports, the following reports are available by default:

1. Most Recent Milestone report — provides information about instances based on the most recent milestone passed.

2. Milestone Performance report — focuses on all milestones over the lifetime of instances tied to a given model. The elapsed time between a milestone and the following milestone will be aggregated together into an average to identify how long instances are taking to progress and identify hotspots.

3. Instances report — focuses on the Instances of a particular Insight Model. The report can show the Summary or Detail views.

4. Exception - Instances in Error Status report — provides information tracked about the identified error milestones. The instances which have reached an error milestone most recently are reported.

5. Exception - Stuck Instances report — provides information tracked about the milestones with a currently executing duration exceeding the Threshold (seconds). Only open instances are included in the report.

For more information about Reports, see Working with Reports in Oracle Fusion Middleware Oracle Real-Time Integration Business Insight User's Guide.

Adding Custom Reports

Oracle Real-Time Integration Business Insight provides you an option to add custom reports. You can configure the data that the custom reports display.

To add custom reports:

1. Log into BI Publisher as an administrator.

2. Navigate to Catalog.

3.  Navigate to Shared Folders/Oracle Integration Insight Reports.

4. Locate the folder provided by the Insight distribution named Custom Reports.

5. Create and copy a report into this folder.

   1. Create a report using BI Publisher by querying the JDBC data source named Insight.

   2. Parameters are limited to types Menu, Date, and Text.

   3. The report will be available immediately within Oracle Real-Time Integration Business Insight console. Hence, it is recommended to build the report in another folder and copy only the validated report to Custom Reports folder when the report runs as expected.

6. Refresh the Reports page in Oracle Real-Time Integration Business Insight console.

The new custom report now appears below the default reports.