Skip to content

A dimension here is not an OLAP dimension and not a reporting axis. Take one statement: “this pump is on shelf A‑22”. It carries when — when it was true, and when it was known — whose word it is, and which source it came from. Where the pump sits is containment: the shelf is in a store, at a station, and the placement is itself such a statement. A later scan that says otherwise is a second statement beside the first, not an edit to a row.

That is why they have to be modelled together. A system that stores the place but not whose word it is cannot tell you whether to trust it. A system that stores the timestamp but not what you knew at the time cannot show what a past decision stood on. The four are most useful in combination, and a row holding one value at a time cannot express the combination.

Ask once

One question pins all four at once

Answering each question separately and reconciling the answers by hand is what your team does today. The point is to ask once.

Set the date, the standing you’ll accept and the match strength once; every part of the answer uses them. Change one and the whole answer re-resolves — raise the match floor and fewer records count as the same thing, the rest listed beside the answer as unconfirmed; count only what somebody confirmed and every position nobody checked empties; move the date and the picture re-tenses. One change, and the answer is honestly different.

Ask something that needs all four.

Bring the question. We will model it and run it.