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

Get Pro SQL Server 2012 BI Solutions 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.