Migration Workbench | Workspace: Sample data
RE
Report inventory › Clearance Rate by Offense - Agency J (2026 YTD)
WI

Clearance Rate by Offense - Agency J (2026 YTD)

Migrate
SAP BusinessObjects Web Intelligence web intelligence document  ·  /Public Folders/Agency J/NIBRS/Clearance Rate by Offense - Agency J (2026 YTD)
Definition
Source
BusinessObjects 4.3 (Web Intelligence)
Object
Web Intelligence document
Owner
Administrator
Data access
SQL query
Layout
List
Parameters
None
Tables
incident
Columns
i.agency_id, i.cleared, i.occurred_date, i.offense_code
Complexity
Simple
Formatting
Standard
Usage (12 months)
Runs
969
Users
151
Last run
9/30/2026 11:02 AM
Failures
24
Migration
Family
F003 Clearance Rate by Offense
Target
Paginated report
Wave
Wave 2
Validation
Match
Connector notes
  • Query plan read from data provider Query 1 (Justice Reporting.unx).
  • 1 document variables to recreate as DAX measures or report expressions.