Validation › Copy of Location Type Analysis

Compare results

MismatchCJIAgency L onlyAccess logged

Object: Copy of Location Type Analysis · Source: IBM Cognos Analytics · Target: Power BI report · Parameters: Agency L, 1/1/2025 to 12/31/2025

Download evidence Audit trail Open familyRefresh

Finding: Blank location types dropped. (Defect seeded on purpose in this sample workspace.)

Checks

Check	Source (Cognos)	Target (Power BI)	Result
Row count	7	6	Mismatch
Total of incidents	1,528	1,308	Mismatch
Record hash	3c83293c4ef5	7d6d9bd92c30	Mismatch

Access and audit

Classification: CJI
Row security: By agency AC-3
Session: MFA, CJIS-trained user IA-2(1)
Data location: Agency network SC-28
Run by: Validation service, read only AC-6
This view: Logged AU-2
Evidence: Retained with the release AU-11

CJIS Security Policy controls

In source, missing in target (1)

beat	location_type	incidents
B122	(blank)	220

Source query

SELECT i.beat,
       i.location_type,
       COUNT(*) AS incidents
FROM incident i
WHERE i.agency_id = 12
  AND i.occurred_date BETWEEN '2025-01-01' AND '2025-12-31'
GROUP BY i.location_type

Power BI dataset query

SELECT i.beat,
       i.location_type,
       COUNT(*) AS incidents
FROM incident i
WHERE i.agency_id = @Agency
  AND i.occurred_date BETWEEN @DateFrom AND @DateTo
  AND i.location_type IS NOT NULL
GROUP BY i.location_type