Creating Reference Dimensions

You might want to use a Referenced relationship type in two situations. The first is when a snowflake dimension table is shared by multiple dimensions. The second is when the attributes of a dimension are not all stored in the same data source. In either case, the fact table contains a dimension key column that you can use to create a direct relationship to a dimension table, and the dimension table contains a foreign key column that you can use to create a relationship to a second dimension table. The fact table is indirectly related to the second dimension table by means of the first dimension table.

You can use a Referenced relationship type when a fact table contains a dimension key column that can be used to create ...

Get Microsoft® SQL Server® 2008 Analysis Services Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.