Migration Workbench | Workspace: CJIS environment Sample data
MFA RE

Assessment summary

Regional Justice Reporting  ·  1 source: Cognos 11.2 (Regional)  ·  Target: Power BI
Reports scanned
565
46 semantic layer
Migrate
137
Report families
Consolidated
227
Duplicate reports
Retire
201
No runs in 12 months
Validated
284
of 331 match
Mismatches
47
Report runs
0.0K1.0K2.0K3.0K4.0K5.0K2025-10: 4,068Oct 252025-11: 3,818Nov 252025-12: 4,069Dec 252026-01: 3,885Jan 262026-02: 3,577Feb 262026-03: 3,934Mar 262026-04: 3,761Apr 262026-05: 3,910May 262026-06: 3,920Jun 262026-07: 3,917Jul 262026-08: 3,970Aug 262026-09: 3,850Sep 26
Complexity
Simple76
Medium40
Complex21
Target
Paginated report116
Semantic model17
Power BI report4
Top report families
FamilyIDSourcesReportsRuns (12 mo)ComplexityTargetWave
Incident ListingF001Co 163,808SimplePaginated reportWave 1
Monthly Crime TrendF002Co 283,215MediumPower BI reportWave 1
Location Type AnalysisF003Co 243,172MediumPower BI reportWave 1
Part A Offense CountsF004Co 242,803MediumPaginated reportWave 1
Clearance Rate by OffenseF005Co 222,615SimplePaginated reportWave 1
Arrests by ChargeF006Co 182,584SimplePaginated reportWave 1
Burglary by BeatF007Co 272,438MediumPaginated reportWave 1
Drug and Weapon ViolationsF008Co 201,720SimplePaginated reportWave 1
Citations by ViolationF009Co 221,545MediumPaginated reportWave 1
Group B Arrest ReportF010Co 281,507MediumPaginated reportWave 1