Summary

In this chapter, you learned some of the benefits of having OLAP cube over the data warehouse. Then we learned how to create cubes and dimensions in the SSAS Multidimensional. We've walked through how to create hierarchies and modify dimensions and measure properties. Then we saw how to create calculated columns in the data source view. Some of the changes had to be made in the cube as a calculation; we used MDX, which is a query language for SSAS Multidimensional, to create calculated measures and a named set. Finally, we saw how to deploy an analysis services project to the SSAS Server and how to load data into the database while processing.

There are still many aspects in Analysis Services multidimensional that need to be studied in a more detailed way. We strongly recommend that you use one of the good books written on SQL Server Analysis Services in order to dive deep in to all the aspects of Analysis Services and learn how to face real-world scenarios with SSAS Multidimensional.