Ops Report Samples

Sample versions of the ops reports, built as single HTML files. Each report opens in any browser and needs no database connection. The data is built into each file.

Phase 1 reports

ReportSourceSample reportApproval statusApproved by
Revenue By StateDatawarehouseNCMOpen reportPending
SE only
WorkloadService EngineOpen reportApprovedNCM Business Team
TE SurveyService EngineOpen reportPending
Supplier SurveyService EngineOpen reportPending

Phase 2 reports

ReportSourceSample reportApproval statusApproved by
Revenue By StateDatawarehouseNCMOpen reportPending

Folders

Phase1/
Reports for Phase 1, OpenPoints.md, and Docs/ listing the files each report was built from.
Phase2/
Reports planned for Phase 2, with more report forms and options.
Queries to generate sample reports/
The SQL behind the samples: DW queries (DatawarehouseNCM), SE Queries (Service Engine) and Transactional db queries.

Each report has filter notes on the left, the filters panel, the report, and field and value notes on the right. The numbers are a snapshot taken when each file was built; to refresh a report, re-run its queries and rebuild the file.