Summary

In this chapter, we've looked more closely at the problems we're likely to face when designing real-world cubes. We saw how to configure measures to aggregate in the way we wanted, how to create new measure groups and handle the problems of different dimensionality and granularity, and we've started to look at the different types of relationships that are possible between dimensions and measure groups. In the next chapter we'll continue with that theme and explore drillthrough (which is related to the topic of fact relationships) and many-to-many relationships.