Chapter 10. Introduction to MDX
In this chapter, we'll work with Multidimensional Expressions (MDX), which is the native query language for SSAS. MDX is a SQL-like language used to query SSAS cubes.
Although there will be situations that cause you to write MDX expressions or queries "from scratch," the design of the BIDS interface really minimizes your need to author much of the MDX that you'll need for your BI project in this way. A large number of MDX templates, samples, and wizards are available in BIDS and SSMS for you to use and customize.
Unlike working with relational databases where you are probably accustomed to authoring many T-SQL scripts, when working with SSAS cubes, you need more of a reading than a writing knowledge of MDX for typical ...
Get Foundations of SQL Server 2005 Business Intelligence 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.
