Nonstar Dimensions

You will probably be able to model the majority of your dimensions using the standard star schema. As SSAS gives you the flexibility to model cube measures by basing them on multiple source fact tables, it also gives you the ability to model dimensions in configurations other than simple star schemas. The types supported are listed briefly here and explained more fully in the following sections:

  • Snowflake: This dimension is based on more than one table. This is called a referenced dimension in BIDS.
  • Degenerate: This dimension is based on a column value from one of the fact tables, rather than using a dimension table. This is called a fact dimension in BIDS.
  • Parent-child: This dimension is based on a hierarchy derived from ...

Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.