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

MDX Query Syntax

Your journey to understanding MDX syntax begins with understanding the core terminology of Analysis Services. We’ll review that terminology first. Next, you’ll learn about the basic syntax used in MDX queries. Once you have a grasp of the syntax, you’ll be ready to write your first query. Then you’re on the road to discovering business intelligence from your data.

Understanding the Core Terminology

To understand basic MDX syntax, the following are some core OLAP terms used in SSAS:

  • Cube: Also called an implementation of the Unified Dimensional Model (UDM), this is the core structure in SSAS. MDX also contains the concept of subcubes, which, as the name suggests, are subsets of your enterprise cube. You explored the UDM in

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