Row-Level Security
One person duplicates a workbook, forgets the filter, and the report renders perfectly for everyone. That is the failure mode to design against.
One person duplicates a workbook, forgets the filter, and the report renders perfectly for everyone. That is the failure mode to design against.
The disagreement is never about SQL. It is about which denominator, which period, and which rows were excluded — decisions nobody wrote down.
The same filter copied into seventeen dashboards is seventeen definitions. A semantic layer exists so there is one.