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