Whose Revenue Number Is Right? Metric Definitions and the Semantic Layer
The disagreement is never about SQL. It is about which denominator, which period, and which rows were excluded — decisions nobody wrote down.
The disagreement is never about SQL. It is about which denominator, which period, and which rows were excluded — decisions nobody wrote down.
Last quarter’s board deck no longer reproduces, and nothing in the dashboard says why. The definition changed on Tuesday.
The same filter copied into seventeen dashboards is seventeen definitions. A semantic layer exists so there is one.
Shipping application code changes behavior; shipping transformation code changes history too. What that asks of models, tests, documentation, and deployment.