O'Reilly logo

Foundations of SQL Server 2005 Business Intelligence by Lynn Langit

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required