O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, Lynn Langit

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

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

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