5 Working with Reports

Oracle Real-Time Integration Business Insight provides advanced and extensible reporting out of the box. Reporting functionality is provided by the reporting capabilities of Oracle Business Intelligence Enterprise Edition (OBIEE). The Administrator must configure the application to point to a running instance of OBIEE.

The reports include a rich set of functionality including the ability to generate details on healthy instances, determine instances that are stalled or in an error state, and identify milestones that are likely bottlenecks in an integration application.

Note:

Only users with the role InsightModelCreator/InsightExecutive/InsightAdmin can run reports.

For details about reports configuration, see Configuring Reports in Oracle Fusion Middleware Oracle Real-Time Integration Business Insight Administrator's Guide.

5.1 Default Reports

Oracle Real-Time Integration Business Insight provides a set of default reports.

The out of the box reports available in Oracle Real-Time Integration Business Insight are:

  1. Most Recent Milestone report

  2. Milestone Performance report

  3. Instances report

  4. Exception - Instances in Error Status report

  5. Exception - Stuck Instances report.

For more information about setting up the reports, see Understanding Reports in Oracle Fusion Middleware Oracle Real-Time Integration Business Insight Administrator's Guide.

5.2 Running Most Recent Milestone Report

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

Only users with the role InsightModelCreator/InsightExecutive/InsightAdmin can run reports.

To run the Most Recent Milestone report:

  1. Click the Reports tab or the Reports Tile on the Home page.
    The Reports page opens.
  2. Click Most Recent Milestone.

    Figure 5-1 Most Recent Milestone Screen

    Most Recent Milestone Screen
  3. Select a suitable Report Format: HTML or PDF.
  4. Select one model for which you want to generate the report in the Insight Model drop-down list.
  5. Select all Milestone(s) you want to be included in the report.
  6. Select the Milestone Status you want to include in the report.
  7. Select the Date Range.
    1. Select a Begin date from the calendar.
    2. Select an End date from the calendar.
  8. Click Run Report to run the report with the provided details.
  9. Click Reset to reset all the fields.
The Most Recent Milestone Report is available.

Figure 5-2 Most Recent Milestone Report

Most Recent Milestone Report

5.3 Running Milestone Performance Report

The 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.

Note:

Only users with the role InsightModelCreator/InsightExecutive/InsightAdmin can run reports.

To run the Milestone Performance report:

  1. Click the Reports tab or the Reports Tile on the Home page.
    The Reports page opens.
  2. Click Milestone Performance.

    Figure 5-3 Milestone Performance Screen

    Milestone Performance Screen
  3. Select a suitable Report Format: HTML or PDF.
  4. Select one model for which you want to generate the report in the Insight Model drop-down list.
  5. Select one or more Milestone(s) you want to be included in the report.
  6. Select the Date Range.
    1. Select a Begin date from the calendar.
    2. Select an End date from the calendar.
  7. Click Run Report to run the report with the provided details.
  8. Click Reset to reset all the fields.
The Milestone Performance Report is available.

Figure 5-4 Milestone Performance Report

Milestone Performance report

5.4 Running Instances Report

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

Only users with the role InsightModelCreator/InsightExecutive/InsightAdmin can run reports.

To run the Instances report:

  1. Click the Reports tab or the Reports Tile on the Home page.
    The Reports page opens.
  2. Click Instances.

    Figure 5-5 Instance Report Screen

    Instance Report Screen
  3. Select a suitable Report Format: HTML or PDF.
  4. Select the required Template: Instances - Summary Report or Instances - Detail Report.
  5. Select one model for which you want to generate the report in the Insight Model drop-down list.
  6. Select one or more Most Recent Milestone(s) you want to be included in the report.
  7. Select one or more Instance Status.
  8. Select the Date Range.
    1. Select a Begin date from the calendar.
    2. Select an End date from the calendar.
  9. Click Run Report to run the report with the provided details.
  10. Click Reset to reset all the fields.
The Instances report is available.

Figure 5-6 Instances Report

Instances Report

5.5 Running Exception - Instances in Error Status Report

The 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.

Only users with the role InsightModelCreator/InsightExecutive/InsightAdmin can run reports.

To run the Exception - Instances in Error Status report:

  1. Click the Reports tab or the Reports Tile on the Home page.
    The Reports page opens.
  2. Click Milestone Performance.

    Figure 5-7 Exception - Instances in Error Status Screen

    Exception - Instances in Error Status Screen
  3. Select a suitable Report Format: HTML or PDF.
  4. Select one model for which you want to generate the report in the Insight Model drop-down list.
  5. Select one or more Milestone(s) you want to be included in the report.
  6. Select one or more required Milestone Status.
  7. Select the Date Range.
    1. Select a Begin date from the calendar.
    2. Select an End date from the calendar.
  8. Click Run Report to run the report with the provided details.
  9. Click Reset to reset all the fields.
The Milestone Performance Report is available.

Figure 5-8 Exception - Instances in Error Status Report

Exception - Instances in Error Status Report

5.6 Running Exception - Stuck Instances Report

The 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.

Only users with the role InsightModelCreator/InsightExecutive/InsightAdmin can run reports.

To run the Exception - Stuck Instances report:

  1. Click the Reports tab or the Reports Tile on the Home page.
    The Reports page opens.
  2. Click Milestone Performance.

    Figure 5-9 Exception - Stuck Instances Screen

    Exception - Stuck Instances Screen
  3. Select a suitable Report Format: HTML or PDF.
  4. Select one model for which you want to generate the report in the Insight Model drop-down list.
  5. Select the Milestone(s) you want to be included in the report. You can select multiple milestones.
  6. Select one or more Milestone Status.
  7. Select the Date Range.
    1. Select a Begin date from the calendar.
    2. Select an End date from the calendar.
  8. Enter a threshold value in the Threshold (seconds) field. The default threshold is 600 seconds which equates to 10 minutes. A few other examples are given below.
    For a threshold of:
    • 3 days, use 259200

    • one day, use 86400

    • 8 hours, use 28800

    • 2 hours, use 7200

    • 1 hour, use 3600

    • 30 minutes, use 1800.

  9. Click Run Report to run the report with the provided details.
  10. Click Reset to reset all the fields.
The Milestone Performance Report is available.

Figure 5-10 Exception - Stuck Instances Report

Exception - Stuck Instances Report