Migration Workbench | Workspace: Sample data RE

Report inventory › Clearance Rate by Offense - Agency E (2024)

WI

Clearance Rate by Offense - Agency E (2024)

Consolidate

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

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: 346
Users: 135
Last run: 9/29/2026 9:28 AM
Failures: 13

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.