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 Administering Oracle Real-Time Integration Business Insight.

5.1 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 Administering Oracle Real-Time Integration Business Insight.

5.2 Running Most Recent Milestone Report

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

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

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

   
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

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

   
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

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

   
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

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

   
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

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

   
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