Migration Workbench | Workspace: Sample data RE

Report inventory › Clearance Rate by Offense - Agency C (Last 90 Days)

WI

Clearance Rate by Offense - Agency C (Last 90 Days)

Consolidate

SAP BusinessObjects Web Intelligence web intelligence document · /Public Folders/Agency C/NIBRS/Clearance Rate by Offense - Agency C (Last 90 Days)

Open family F003 Validation result

Overview Query Source definition

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: 13
Users: 13
Last run: 8/31/2026 6:44 PM
Failures: 1

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.