Abstract: A data warehouse includes a plurality of master data tables. The master data tables include surrogate identifiers. Each surrogate identifier (SID) identifies a master data table domain inside a master data table from the plurality of master data tables. A plurality of dimension tables use the surrogate identifiers to link to the master data table domains within the master data tables. A fact table stores dimension identifiers (DIM IDs) that provide links to the dimension tables. A domain fact table stores aggregated data aggregated from data stored in the master data tables. The aggregated data is accessible from the domain fact table using surrogate identifiers, without using DIM IDs stored in the fact table.