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

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.