Migration Workbench | Workspace: Sample data RE

Report inventory › Clearance Rate by Offense - Agency H (2026 YTD)

WI

Clearance Rate by Offense - Agency H (2026 YTD)

Consolidate

SAP BusinessObjects Web Intelligence web intelligence document · /Public Folders/Agency H/NIBRS/Clearance Rate by Offense - Agency H (2026 YTD)

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: 8
Users: 8
Last run: 9/22/2026 3:34 PM
Failures: 0

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.