A weekly reporting workflow that stops when its sources are incomplete

Описание и применение

Внедрён поток отчётности, который блокирует утверждение, если источники данных отсутствуют или устарели, гарантируя, что только достоверные отчёты могут быть утверждены.

Задача

Weekly reports can contain plausible numbers yet be misleading if source data is missing or stale, leading to uninformed decisions.

Результат

The prototype demonstrates a robust reporting pipeline that halts when source data is incomplete or stale, ensuring only accurate reports are approved.

Рабочий процесс

• Define metric sources and their freshness thresholds.
• Generate report from synthetic billing, CRM, and support snapshots.
• If a source is missing or stale, omit its metrics and add a blocker.
• Set report status to "blocked" if any blockers exist, otherwise "draft".
• Compute a SHA‑256 digest of the report content and input digest.
• When approving, verify the digest matches, the status is "draft", and no blockers remain.
• Reject approval if any condition fails.
• Record reviewer name and timestamp on successful approval.

Доказательства

The report keeps the metrics it can calculate, omits the unavailable ones and records a blocker.

Источник

The approval function recomputes it and checks that the report is still a draft without blockers.

Источник