- Before
- Asks an analyst for anything the weekly reports do not cover, and decides before the answer comes back.
- Now
- Asks in plain words, reads the SQL and the definitions, and validates the answers her team shares.
One question, from typed to validated
Monday, Oct 5 to Sunday, Oct 11, 2026. Lena Ortiz runs supply for EMEA and wants to know which backorders this week’s arrivals will clear. Here is what happens, screen by screen, in the working solution.
- 01Morning
What needs her, before she asks anything
Lena Ortiz · Supply chain director, EMEALena opens the solution: 214 questions asked this week by 31 people, a median of 3.4 s to an answer, 2 questions stopped by the guardrails. Under “Needs you”: a forecast answer waiting for her validation, 7 SKUs below safety stock at Plant 3 — Leiden (up from 4 yesterday), and a cold-chain shipment that logged 8.6 °C for 22 minutes.
Watched numbers: “Nightly validation — 34 real questions · 34 / 34 · all passing.”
- 022.9 seconds
“Which backordered SKUs in EMEA have stock in transit arriving this week?”
Lena Ortiz · Supply chain director, EMEAThe question is screened, and the orchestrator sends “backordered” to the Backorders specialist and “in transit arriving this week” to the In-transit specialist. The answer: 6 of the 14 SKUs on backorder in EMEA have stock arriving — 7,800 units against 6,295 backordered. Four are fully covered; CVT-SH-7F11 and NXL-DES-2515 stay short by 490 units between them.
“NXL-BC-3020 lands Oct 10 but needs incoming quality release, so it can ship from Oct 12.”
- 03One click
The SQL each specialist ran, and the definitions it used
Backorders and In-transit specialistsUnder Query & reasoning sit the two SELECT statements: the Backorders specialist read 1,284 open lines in 0.8 s, the In-transit specialist 37 shipment lines in 0.7 s. The reasoning spells out every assumption — “EMEA” is the order’s ship-to region, not where the stock sits; “this week” is Oct 5 to Oct 11 by carrier ETA; stock already received counts as on hand, not in transit.
“The orchestrator joined the two results on SKU in the answer itself — the warehouse only ever saw two read-only queries.”
- 04Traced
Every table the answer came from, and how fresh it was
Lena Ortiz · Supply chain director, EMEALineage lists the four tables read: backorder lines from order management (ERP), refreshed 06:10; the product master, 02:00; inbound shipments and shipment lines from transport management, 06:05 — with the row count read from each.
“Every number in this answer comes from these tables. Nothing was written back.”
- 05Follow-up
“And the forecast impact?” — without asking twice
Forecast and Inventory specialistsThe follow-up carries over the 6 SKUs from the last answer. The Forecast specialist reads the approved September S&OP version for the next four weeks; the Inventory specialist reads free stock and confirmed receipts. Two SKUs stay at high risk: CVT-SH-7F11’s shortfall grows from 280 to about 1,480 units before its Nov 2 receipt, and NXL-DES-3018 runs out around Oct 17, about 300 short until Oct 21.
Bias shown so the forecast can be judged: CVT-SH-7F11 demand ran 14% above forecast over 8 weeks.
- 06Stopped
A request to change data is stopped before any query
Question screenerAt 08:03 Priya Raman, planning APAC, typed “Update the ETA for SHP-EU-40851”. The question screener reads it as a request to change data and stops it — asked again here, it gets the same stop: no SQL written, 0 tables touched, the full text logged for the quality reviewer.
“Supply Chain Answers only reads. Shipment ETAs, orders and stock are changed in their own systems by the teams that own them — nothing was sent to the warehouse.”
- 07Saved
The answer joins the Library, waiting for her check
Lena Ortiz · Supply chain director, EMEALena saved the forecast answer from Ask at 06:14. In the Library it sits beside the team’s other saved answers — re-run after the 06:10 warehouse load, scheduled or not, each marked Validated, To validate, Numbers changed, Quality review, Shared or Up to date. This one says To validate.
- 08Before sharing
Three checks, then her name on it
Lena Ortiz · Supply chain director, EMEAValidating asks her to confirm three things: she checked the numbers against the source tables, the reasoning matches how the team defines these terms, and the expected answer is saved for the nightly runs — match rule: totals within ±1%.
“A validated answer joins the shared set. If the answer drifts, you are asked to review it.”
- 09Validated
On the record, and asked again tonight
Lena Ortiz · Supply chain director, EMEAThe history now reads: Lena Ortiz validated it — signed, expected answer saved, asked again tonight at 02:00. The nightly set grows from 34 to 35 questions.
“Validated — now 35 questions in the nightly set.”
- 10Every night
The answers the team relies on, re-checked against the warehouse
The nightly validationAt 02:00 every validated question is asked again and compared with its expected answer. The dashboard shows each night’s score — one night in the last seven came in at 33 of 34 — beside questions answered per week, which specialists answered, time to an answer, and every question the guardrails stopped.