Solutions / Supply chain
Trace a reported issue
back to its source.
Which tire-issue orders can be traced to Supplier A’s September material batches? What is their total order value?
The question
Which orders trace back to this supplier’s material batches?
Fictional records · Runnable calculation
- Supplier
- Batch
- Product
- Order
Supplier→Material batch→Product→Order→Feedback
Supplier A and all record identifiers belong to a fictional dataset. The background ontology map uses object types only.
What the model needs to know.
| Object type | Source information | Relationship |
|---|---|---|
| Material batch | Supplier ID, supplied date | Supplied by Supplier |
| Product | Product ID, batch ID | Uses Material batch |
| Order | Order ID, product ID, amount | Contains Product |
| Feedback | Order ID, topic, confirmed status | Refers to Order |
The definition changes the answer.
01
All tire reports · $99,500
Three orders match: SO-1042, SO-1048 and SO-1051. Four feedback records support the result.
02
Confirmed only · $67,000
SO-1048 drops out because its feedback has not been confirmed. Two orders and three feedback records remain.
03
Count each order once
Two feedback records refer to SO-1042. Its $48,000 order amount is still added once. This is order value, not a forecast of loss.