Summary

In this chapter, we reviewed basic MDX syntax and querying. We then discussed the core objects that you might add to an SSAS cube: calculated members, named sets, and script commands. We next reviewed the most commonly used MDX functions and some of the new ones as well. The last area we covered was the new and powerful capability to associate assemblies with SSAS.

In the final chapter, we’ll explore the toolset available in SSAS for data mining.

Get Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition 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.