Validation › Vehicle Crime Summary - Agency D (2024)

Compare results

Match

Object: Vehicle Crime Summary - Agency D (2024) · Source: SAP BusinessObjects Web Intelligence · Target: Power BI report · Parameters: Agency D, 1/1/2024 to 12/31/2024

Download evidence Audit trail Open familyRefresh

Checks

Check	Source (Web Intelligence)	Target (Power BI)	Result
Row count	2	2	Match
Total of incidents	373	373	Match
Total of loss	730,401.11	730,401.11	Match
Record hash	ee41f0fd7b0f	ee41f0fd7b0f	Match

Access and audit

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

Source query

SELECT i.offense_code,
       COUNT(*) AS incidents,
       SUM(i.property_loss) AS loss
FROM incident i
WHERE i.offense_code IN ('23F','240')
  AND i.agency_id = 4
  AND i.occurred_date BETWEEN '2024-01-01' AND '2024-12-31'
GROUP BY i.offense_code

Power BI dataset query

SELECT i.offense_code,
       COUNT(*) AS incidents,
       SUM(i.property_loss) AS loss
FROM incident i
WHERE i.offense_code IN ('23F','240')
  AND i.agency_id = @Agency
  AND i.occurred_date BETWEEN @DateFrom AND @DateTo
GROUP BY i.offense_code