An intermediate dimension table is in turn joined to both the intermediate fact table and to the fact table on which the measure group specified by the relationship is based.