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