O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

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

Working with the query designer

You are probably familiar with the T-SQL language that we use to query data from SQL Server, that is, OLTP. But Analysis Services requires a different language for querying OLAP cubes, which is called Multidimensional Expressions or, simply, MDX. For more information on Querying Multidimensional Data with MDX, check http://msdn.microsoft.com/en-us/library/bb500184.aspx.

Note

Another language used in SSAS is the prediction query language called Data Mining Extensions or DMX. DMX is used in data mining model to predict unknown values in a dataset. You also probably heard about Data Analysis Expressions or DAX, which is a formula language used in PowerPivot workbooks in Excel.

You need to learn and understand MDX if ...

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