RMS2 Dashboard Release Notes
RMS2 Dashboard Release Notes
Table of Contents
TOC \o "1-3" \h \z \u Table of Contents PAGEREF _Toc75424128 \h 1
OverView PAGEREF _Toc75424129 \h 1
Dashboard PAGEREF _Toc75424130 \h 1
Software Configuration Summary PAGEREF _Toc75424131 \h 2
Parameter Relationships PAGEREF _Toc75424132 \h 3
RMS Dashboard Operational Notes PAGEREF _Toc75424133 \h 3
Dashboard Internal RDL Structure PAGEREF _Toc75424134 \h 3
User Interface Componets PAGEREF _Toc75424135 \h 4
Dashboard Forms and Pages PAGEREF _Toc75424136 \h 5
OverView
Dashboard
The RMS2 SSRS dashboard report set is a defined set of SSRS report displays designed to provide an administrative view of the data contained within the RMS2 2 application. Dashboard display items include collections of tables, charts and graphs along with a set of interactive elements allowing the user to interact with and control the information sets rendered within the report by clicking on the related control. The Dashboard features an integrated set of drill through report displays and informational display controls that provide a variety of data relationship visualization displays based on recent agency activity. As such the displays are all based on the current day and a user specified preceding period (in days). Dashboard displays are designed for viewing (not printing) and expand automatically to best render the data, as such the displays are likely to exceed standard print capabilities.
The current release has been updated with a greater color contrasting display for easier element recognition.
Software Configuration Summary
The Dashboard is a collection of SSRS report provided within a single VS project set to support the namespaces provided in SQL Server 2008 R2 or higher SSRS. All elements are contained within the published RDL files, and no dependencies on external files exist. Deployment requires deploying the RDL to the agencies SSRS server, and the addition of data values to the RMS2 database to make the dashboard visible within the EIS Report Viewer, and to provide default parameters used within the pages to organize agency data. Deployment requires the following:
Build and deployment of the RDL’s to the agency SQL Server SSRS instance.
Add a single report reference to the e_lawReports table. This reference will allow the EIS Report Viewer to access the report.
Launch page should be set to “Home”
Add and configure the SSRS parameters to the e_law c_table_data table. You may wish to add a c_table reference to the SSRS-PARAMETER table to allow modification of the reporting parameters within the EIS RMS manager.
Parameter Relationships
CLOSEDSTATUS – defines the code(s) used by the agency to indicate that a case has been closed. This is used in the case management displays within the dashboard related to the officer productivity and overall case closure rates. The system_code_value is what is processed by the dashboard, so the appropriate values need to be added to this field. If the agency utilizes multiple closure codes then simply indicate with a comma “, “ between the elements (e.g. CLOSED, UNFOUNDED).
OPENSTATUS – defines the code(s) used by the agency to indicate that a case is open. This is used in the case management displays within the dashboard related to the officer productivity and overall case load. The system_code_value is what is processed by the dashboard, so the appropriate values need to be added to this field. If the agency utilizes multiple closure codes then simply indicate with a “, “ between the elements (e.g. OPEN, ACTIVE).
DAYDIFF – Provides the default day span used throughout the reporting solution to control the returning data set. MUST be set in number of days and should NOT exceed 90 (days).
SHOWCAD – indicates if the CAD informational displays should be enabled and should only be set to YES if the agency is utilizing the EIS CAD system AND if there exists a CAD data source within the SSRS server. YES, enables the control within the dashboard, NO suppresses the control.
RMS Dashboard Operational Notes
The RMS dashboard has been developed to utilize the standard RMS2 internal multi-agency access control. The RMS dashboard utilizes the UserAgency parameter value as a filter criteria for all forms, and as such can be deployed to sites utilizing a multi-agency environment.
The RMS dashboard assumes all arrests are recorded within the incident module as a physical arrest. If the agency does not record arrests in this fashion the dashboard arrest calculations will not provide accurate information as part of the agency arrest summaries or he officer productivity summary.
Dashboard Internal RDL Structure
The Dashboard report is a series of linked SSRS reports and sub reports. The governing report is the application header and all other displays are launched from the header (or from within other reports). The main RDL is:
Home.rdl. This is the primary RDL and should always be the launching RDL for the dashboard collection. must be referenced the e_lawreports table.
In keeping with this hierarchy, all of the supporting RDL’s are names using a report name preface or “WIDGET_RMS” to denote the RDL as a supporting component within the RMS dashboard (or “WIDGET_JMS” if within the jail).
User Interface Componets
The Dashboard applications include different types of User Interface (UI) controls to assist the user with the defining of reporting parameters and for general navigation. The dashboard includes the following type of interactive controls:
Command/Navigation Buttons – provides a single click navigational control that will route the user to a new display form.
Hyper-Links – direct hyperlinks are provided in some displays where the text displayed provides a valid association with a secondary, more detailed report. Hyperlinks are only used to access additional details related to the initiating item.
Radio-Buttons – a Visual radio button collection allows the user to select one (or multiple) of a set of values to be used within the report. Selected items within the radio button collection will be used as filter criteria associated with the data underlying, he displayed report page.
Back Buttons – Simply allows the user to return to the referring or parent page associated with the currently displayed report.
Radio-button type component - The Dashboard(s) are designed to provide an active view of the agencies operational data over a specified period of time, generally the past few days, weeks or months (and in some cases future scheduled events). To simplify the user’s interaction with the dashboard those, display formats that utilize a date range as part of the filter have been developed with a visual radio-button type control for the user to specify the desired time frame.
Dashboard Forms and Pages
The dashboard provides an interactive collection of data displays constructed from the agency’s data contained within the RMS2 database. The pages and sub-ages have been group by a defined set of categories accessible through the primary “Module” navigation buttons displayed as the header on all forms.
Dashboard Header
Daily Activity Statistics – Displays a collection of graphs, charts and data tables summarizing recent agency activity across multiple modules. Designed to allow administrative staff to quickly view recent activity in daily intervals over the past 7 days.
Annual Activity Statistics – Displays a collection of graphs, charts and data tables summarizing agency activity across multiple modules. Designed to allow administrative staff to quickly view activity represented as a set of graphs and charts.
Incident Reporting – Tracks the recent incident reporting activity and missing/incomplete reports. Provides summary views and detailed displays of recent reporting activity.
CAD Data – If the agency is utilizing the EIS CAD system the CAD data displays event driven displays related to recent CAD activity.
Officer Activity View – Track agency and personnel performance metrics related to the agency as a whole and specific (selectable) officers.
Case Management – provides a visual window into the case management components of the RMS. Displays assigned case load, case closure stats and other generalized performance metrics.
Recent Persons (MNI) – displays listings of names records recent added to the system and by what means (User, system, etc.). designed to provide the RMS administration group the ability to monitor incoming name information. Contains a linked report that displays possible duplicate ID values used in multiple records.
Extraction – provides a set of standard data extraction reports, designed to be output to common data exchange formats, such as excel or CVS for use in external programs or crime analysis tools. Can also provide direct hotlinks to other standard EIS statistical reports.
Source: RMS Dashboard Guide.docx