You are working on a BI reporting pipeline for a finance and operations dashboard. The same metric can be defined in multiple places today, and analysts are seeing mismatched numbers across reports. You need a consistent way to decide where each calculation belongs so the pipeline stays maintainable and the output stays trusted.
How do you decide whether a calculation should be done in the database, in the BI tool, or in the semantic layer?