O'Reilly logo

Foundations of SQL Server 2008 R2 Business Intelligence, Second Edition by Guy Fouché, 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

C H A P T E R  13

Image

Introduction to MDX

In this chapter, you’ll work with Multidimensional Expressions (MDX), which is the native query language for SQL Server Analysis Services (SSAS). MDX is a SQL-like language used to query SSAS cubes.

Although there will be situations that will require that you 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 projects. 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 ...

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