There are 3 main places to put the Business Intelligence of Calculations Centralized in the database model pre-calculated using ETL (Extract Transform and Load) or even using Virtual Columns that evaluate at run time. At the semantic metadata layer (universe objects for business objects evaluated at run time for SQL generation) At the report level … Continue reading Where to put the Business Calculation Rules in Data Warehousing?