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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
