Metric Definitions and the Semantic Layer
Revenue disagreements can arise from definitions, SQL, or different input versions. Trace the population, time basis, calculation, and published result.
Revenue disagreements can arise from definitions, SQL, or different input versions. Trace the population, time basis, calculation, and published result.
The same filter copied into seventeen dashboards is seventeen definitions. A semantic layer exists so there is one.
One question, “what was March revenue?”, can honestly return 600, 550, or 100 from the same seven orders. This post shows how metric contracts, aggregation rules, time-window rules, versions, and consumer tests make one answer.