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 a Many-to-Many Dimension

Typically, a record in a fact table is related to only one record in a dimension table, but a dimension record may be related to many fact table records. For example, each order line is for a single product, but that product may have many order lines. The product dimension and the sales measures have a one-to-many relationship. When a dimension and a measure a have one-to-many relationship, the total value of the measure is equal to the sum of the values of the measure of each of the individual dimension members.

In some situations, a single record in a fact table can be related to multiple records in a dimension table. For example, the Adventure Works sales department often has several account managers working ...

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