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

Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide 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.