The dimension table is joined to an intermediate fact table. The intermediate fact table is joined, in turn, to an intermediate ...