Tecflix

MDX Queries Get Free Access Purchase the entire course

4 December 2013 · · 11403 views

The MDX SELECT Statement

In most cases an MDX SELECT statement is used to retrieve data from a SQL Server Analysis Services cube. Let Chris Webb introduce this important statement to you in this free, 20-minute video. Log-in or get a free account to watch it!

A simple MDX SELECT statement consists of a SELECT clause and a FROM clause. The SELECT clause uses sets to define what appears on rows and columns in a query, while the FROM clause contains the name of the cube that you are querying. The set used on rows cannot contain members from hierarchies that appear in the set on columns, and vice versa. Sets of tuples can be used on any axis to give a nested, or cross-tabbed effect.

A query may also contain a WHERE clause. Unlike in SQL, the WHERE clause doesn’t directly filter what appears on rows or columns, instead it slices the data in your results. You can think of the WHERE clause as an invisible, extra axis that is one tuple deep. When a set is used in the WHERE clause, the results will show aggregated values for all of the members in that set. Rows or columns that only contain null values can be filtered out from your results by adding a NON EMPTY statement before the axis definition in the SELECT clause.

If you would like to learn Multidimensional Expressions with Chris, make sure to watch the remaining videos in our MDX online course.

Log in or register for free to play the video.

  • MDX Basic Concepts 29-min Watch with Free Subscription

  • MDX Queries 24-min Watch with Free Subscription

  • MDX Calculated Members 52-min

  • MDX: Member and Set Functions 38-min

  • What is the MDX Current Member Function? 5-min Free—Watch Now

  • MDX Numeric Functions and CURRENTMEMBER 33-min

  • MDX: Previous Period Growths, Shares & Moving Averages 38-min

  • More MDX Member & Set Functions 1-hour 37-min

  • What is a Subselect in MDX? 3-min Watch with Free Subscription

  • Exists, MDX Solve Order, and Subselects 49-min

  • MDX Performance Diagnosis with Profiler 29-min

Purchase a Full Access Subscription

 
Individual Subscription

$480/year

Access all content on this site for 1 year.
Purchase
Group Purchase

from $480/year

For small business & enterprise.
Group Purchase
 
  • You can also redeem a prepaid code.
  • Payments are instant and you will receive a tax invoice straight away.
  • We offer sales quotes/pro-forma invoices, and we accept purchase orders and bank transfers.
  • Your satisfaction is paramount: we offer a no-quibble refund guarantee.
  • See pricing FAQ for more detail.
In collaboration with
Project Botticelli logo Oxford Computer Training logo SQLBI logo Prodata logo