Ask the Brain

Ask the Enterprise Brain anything...

Query lineage, definitions, pipeline health, freshness, or reconciliation

TO

Enterprise Brain Answered in 5.1s · 11 sources consulted

Variance Decomposition

Cause	Amount	Status
Definition difference — warehouse reports gross revenue, finance nets refunds at source	$1.4M	Confirmed
Freshness gap — warehouse refreshed 7 Aug 02:00, finance closed 5 Aug	$0.6M	Confirmed
Manual journal adjustments (JE-2026-0781, JE-2026-0794) not present in warehouse	$0.3M	Pending confirmation
Total	$2.3M	—

Where the Paths Diverge

Both figures originate from orders_raw. The warehouse path applies transform fct_revenue_v3, which reports gross revenue with refunds as a separate line. The finance system nets refunds at source per accounting policy FIN-ACC-002. The definitions were never reconciled when fct_revenue_v3 shipped in March.

System of Record

Per the Domain Ownership registry, finance holds the revenue system-of-record. The board figure should restate on the net definition.

Recommended Resolution

Restate the board figure using the net definition with a one-line reconciliation footnote covering the freshness and journal components. Draft recon report is ready — requires finance data-owner sign-off on the $0.3M journal attribution.