SQW04 Getting Started with MDX

A session at Live! 360

Wednesday 19th November, 2014

11:00am to 12:15pm (EST)

In this session, we will concentrate largely upon crafting simple MDX expressions and queries.

In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or "slicer"), and begin exploring core MDX functionality, including calculated members, and named sets. This session applies equally to Analysis Services 2008, 2008R2, 2012, and 2014.

You will learn:
An Introduction to MDX - discussing its relevance, uses and basic components
Expose the concept of tuples and explore syntax elements
Examine Illustrative MDX Queries

About the speaker

This person is speaking at this event.
Bill Pearson

SQL Server (BI) MVP, SSAS Maestro, Evangelist, Mercenary. CPA, CITP, CGMA, CMA, CIA, MCSE, MCDBA. wep3@islandtechnologies.com (Who is John Galt?) bio from Twitter

Sign in to add slides, notes or videos to this session

Tell your friends!


Time 11:00am12:15pm EST

Date Wed 19th November 2014

Short URL


View the schedule


See something wrong?

Report an issue with this session