O'Reilly logo

Pro SQL Server 2012 BI Solutions by Caryn Mason, Randal Root

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 14

image

Reporting with MDX Queries

But for me, it was a code I myself had invented! Yet I could not read it.

—Erno Rubik

Multidimensional Expressions (MDX) is a Microsoft-owned specification, not an open standard language. But, it has been adopted by many vendors and is considered an industry standard for querying and manipulating multidimensional data for SSAS.

If you are working with OLAP cubes, you will likely be working with MDX at some point. While you do not have to be an expert in MDX to work with SSAS cubes, acquiring a more in-depth understanding of the language is helpful in a number of ways. For example, calculated members, KPIs, ...

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