Templates / SLA & timers / scheduled-report

Scheduled KPI Report

A timer start event runs this process every day. It queries the warehouse, renders the KPI report and mails it to the distribution list; when the query comes back empty — usually a late upstream load — it alerts the data team instead of sending an empty report.

timer startreportingbatchdata
Open in editor Download .bpmn
casen template use scheduled-report
report empty Query KPIs Renderreport Mail todistributionlist Alert datateam Every day Any rows? Report sent Nodata

Scenarios · 2

  • Yesterday's KPIs are rendered and mailed query-kpis → render-report → distribute-report → report-sent
  • An empty query alerts the data team query-kpis → alert-data-team → no-data

Job types · 4

  • chat-post Alert data team
  • email-send Mail to distribution list
  • report-render Render report
  • warehouse-query Query KPIs

Files · 2

Every scenario passes on @bpmnkit/engine's runScenario in the package's tests. casen template use scheduled-report [dir] writes the files above into your project — see the templates guide for running the scenarios and deploying.

More in SLA & timers