Migration Workbench | Workspace: Sample data
RE
Report inventory › Vehicle Crime Summary - Agency J (2025)
WI

Vehicle Crime Summary - Agency J (2025)

Consolidate
SAP BusinessObjects Web Intelligence web intelligence document  ·  /Public Folders/Agency J/Incidents/Vehicle Crime Summary - Agency J (2025)
Agency_J/Incidents/Vehicle_Crime_Summary_-_Agency_J_(2025).json
{
 "document": {
  "id": 87398,
  "cuid": "A4f530f23778db61aa46f4a",
  "name": "Vehicle Crime Summary - Agency J (2025)",
  "folder": "Public Folders/Agency J/Incidents",
  "owner": "Administrator"
 },
 "dataProviders": [
  {
   "id": "DP0",
   "name": "Query 1",
   "dataSourceType": "unx",
   "dataSourceName": "Justice Reporting.unx",
   "queryplan": "<queryplan custom=\"false\" editable=\"true\"><statement index=\"1\">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 = 10 AND i.occurred_date BETWEEN '2025-01-01' AND '2025-12-31' GROUP BY i.offense_code</statement></queryplan>"
  }
 ],
 "reports": [
  {
   "id": 1,
   "name": "Report 1",
   "elements": [
    {
     "type": "VBarChart",
     "dataProvider": "DP0"
    }
   ]
  }
 ],
 "alerters": [],
 "variables": [],
 "parameters": []
}