O'Reilly logo

Instant MDX Queries for SQL Server 2012 by Nicholas Emond

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

Top 4 features you'll want to know about

As you start to use the MDX Queries, you will realize that there are a wide variety of things that you can do with it. This section will teach you all about the most commonly performed tasks and most commonly used features in the MDX Queries.

Note

The code used for the MDX queries are from the AdventureWorks cube installed in step 6 of the Quick start section.

Using functions

It won't take long for you to realize that you will need to write more than the basic MDX query. The MDX functions and operators are here to help you.

Basic keywords and functions

Basic keywords and functions are use when you need to do more with the MDX queries than just simply listing measure and dimension attributes.

  • CrossJoin: The CrossJoin ...

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