Summary
In this chapter, you have been introduced to aggregations, which is a very powerful tool; it will help you create high-performance Analysis Services cubes. You have seen how aggregations can be created, both through a guided wizard as well as how they can be added to the cube manually. The chapter has also covered how you can use usage-based optimization to create aggregations based on the exact queries that the users issue.
In the next chapter, we will leave multidimensional modeling, and instead concentrate on the new in-memory model that was introduced with SQL Server 2012 called tabular models.
