This section is intended for case managers and department managers reviewing reports.

You must have a solid working knowledge of Oracle Business Activity Monitoring (BAM) before creating or editing the Oracle Public Sector Incident Reporting (PSIR) dashboards and reports. For information on creating and editing Oracle BAM reports, see "Creating and Managing Reports," in Oracle Fusion Middleware User's Guide for Oracle Business Activity Monitoring.

This section covers the Oracle BAM dashboard and reports delivered with Oracle PSIR. Oracle Public Sector Incident Reporting includes one dashboard, the Incident Reporting Dashboard, with two reports. These reports use information from the incident reports submitted in Oracle PSIR. Information from saved incident reports is not used in the reports.

Incident Reporting Dashboard

The Incident Reporting dashboard has two reports - The Incident Activity Monitoring Report and the Incident Analytics Report. Each of these reports has five views pertaining to the type and location of the incidents reported. You can filter the views using the report parameters Incident Type and Incident Location on the Incident Activity Monitoring Report and the parameters Time Period and Incident Location for the Incident Analytics Report. The following provides an explanation and a sample image of the reports and views.

Incident Activity Monitoring

The Incident Activity Monitoring Report contains views from real-time monitoring of the incident reporting business processes to make sure they are run smoothly. This report has five views.

Streaming List

The Streaming List provides a list of Incident Types like Arson, Burglary, Car Jacking and so on. Adjacent to this field are the fields: Incident Date, Incident City, Incident Postal Code, Incident State, and Incident Status.

Number of Incidents List

The Number of Incidents List is a view of each Incident Type and the number of times it has been reported. The view displays the Incident Type in alphabetical order in the extreme left column and towards the right, the frequency of each incident type by day, last seven days, the current month, Year To Date (YTD), and a comparison of frequencies for the day with Last Year Same Day.

Action List

The Action List view displays a list of Too many Open Incidents for the past 24 hours with columns for Message Text, Received Date, and Subject Text from left to right. You can edit the report to view too many open incidents for Homicide using BAM Active Studio.

Incident Type by City

The Incident Type by City is a crosstab view that displays the count of each incident type in each city. From the left, vertical rows for each incident type are listed alphabetically. To the right are columns for each city with the number of incidents per incident type. A count column at the far right tallies the total number of incidents per type and a grand count row at the bottom provides the total number of incidents per city. You can filter the view to show specific selected incidents or cities.

Incoming and Total Open Incidents

The Incoming and Total Open Incidents view is a 3D Combo Chart showing both incoming and open incidents. The line chart shows the open incidents and the bar chart shows incoming incidents. Only incidents opened within the day are shown. The X-axis maps the time through one hour intervals and the Y-axis maps the number of incidents.

Incident Analytics

The Incident Analytics report provides the historical analysis of the incident reporting business process. This report has five views.

Incident Type - Stacked Bar Chart with Incident City Stacked

The Incident Type view displays a bar chart that maps the frequency of incident types with the incident city stacked together in bars. The X-axis maps the incident types in alphabetical order from left to right. The Y-axis maps the frequency of incident types from zero to infinity with the interval width of five incidents.

Incident Status - 3D Bar Chart with Incident City Stacked

The Incident Status 3D bar chart displays the incident status of all incident reports within the chosen time range with the statuses: Closed, Invalid, New, Open, and Withdrawn. These are mapped on the X-axis and the number of incident reports is mapped on the Y-axis with the interval width of 20 incident reports. The incident cities are separated by bars stacked upon each other on the X-axis.

Incident by Location - Bar Chart with Drill-Down from City to Postal Code

The Incident by Location view displays a bar chart with incident locations mapped on the X-axis and the frequency of incidents on the Y-axis from zero to infinity with the interval width of five incidents on the chart. You can apply filters and drill down to specific cities for any comparison. Clicking the bars will break the incidents for that city down into incidents by postal code.

Responder Assignment Statistics

The Responder Assignment Statistics is a crosstab view that displays the average and total time taken to assign a responder to incident reports sorted by each incident type. To the far left is the Incident Type column with the incident types arranged alphabetically. This column is followed by the columns for specific incident locations with counts and averages spread across towards the right. You can filter the view to show specific selected incidents or cities.

Average Resolution Time in Days

The Average Resolution Time in Days view is a bar chart that displays the average time in days for each incident from the time when it is reported to when it is closed. The X-axis shows the incident types alphabetically from left to right with the exact number of days for which the incident has been opened, on the top of the each bar. The Y-axis shows the average time in days starting at 0 to infinity with the interval width of two days until the incident is closed.