What's in this chapter?
In Chapter 2 you ran a simple MDX query to retrieve data from Analysis Services. Building on that, in this chapter you learn the fundamentals underlying the MDX language to manipulate and query Analysis Services objects. You also learn about some advanced concepts, such as MDX operators and functions. This forms the basis for many of the subsequent chapters in this book.
SQL Server 2012 provides a sample Analysis Services project that demonstrates the majority of the Analysis Services features available from www.wrox.com to learn MDX. In addition, this chapter along with Appendix A provides you with examples of MDX queries based on the sample Adventure Works DW Multidimensional project updated for Analysis Services 2012. Some of the MDX queries you need to write to solve business problems necessitate the use of cube space restriction, empty cell removal, and parameterized queries — all concepts covered in this chapter.
Just as Structured Query Language (SQL) is a query language used to retrieve data from relational databases, Multi-Dimensional eXpressions (MDX) is a query language used to retrieve data from Analysis Services databases. MDX supports two distinct modes: