What were Q3 sales?
Two AI agents get the same question about an invented company's quarter. One works from the raw files. One can only ask a semantic layer. Step through what each one does.
Agent on the raw files · run 1 of 3
AI
What were Q3 sales?
orders.csvorder system
shipments.csvwarehouse
invoices.csvERP
Decision 1: what sales means"Defined “sales” as recognized net revenue (invoices minus credit memos), since no definition was given."
Decision 2: which date countsCounts each invoice on the invoice date.
Decision 3: marketplace ordersCounts them at our commission: "a judgment call that moves the answer by $500,000."
Writes its own program. This run: 0 lines
?
Answer
Agent on the semantic layer
AI
What were Q3 sales?
Semantic layer
Definitions
"Sales" with no qualifier means net sales, a rule the CFO and Chief Merchant signed together. Net sales: what shipped in the quarter, net of returns, marketplace at our commission. Owner: CFO.
Dictionary
ship_date: the date the carrier picked up the shipment. NOT the order date.Ontology
Each invoice ties to its line's shipment, matched on order number and line number.
Data
orders.csv
shipments.csv
invoices.csv
In our test the agent was told not to open these, and it didn't. In production you set that as a permission.
?
Answer
Same orders, same shipments. Only the invoice dates move.