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