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

Chapter 7. Advanced Dimension Design

In this chapter, you will learn how to:

  • Create a referenced dimension.

  • Create a degenerate dimension.

  • Add a fact dimension to a cube.

  • Create a many-to-many dimension.

In Chapter 6, you learned how to create measures using additive, pseudo-additive, semi-additive, and non-additive aggregate functions. You also learned basic MDX concepts and created calculated members and script assignment statements. You then created a KPI that used calculated members for its status and trend expressions.

In this chapter, you will learn how to use advanced dimension capabilities. Some attributes appear in more than one dimension. You can create a single dimension for these attributes and then add it to a cube as a reference dimension. ...

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