O'Reilly logo

Microsoft® SQL Server® 2008 Analysis Services Step by Step by Scott Cameron

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required