Reporting Services & MDX Queries – Video Tutorials

3 12 2013

Working with multiple clients lately, mentoring report development on SSAS (mostly Tabular and some multidimensional), this prompted me to create these tutorials to provide some training and follow-on support.

Reporting Services can be a great tool for designing reports using data in an Analysis Services database with MDX queries.  MDX works with either a multidimensional model (containing cubes & dimensions) or a Tabular model using the xVelocity in-memory aggregation engine.  Basic MDX queries can be fairly easy but graduating beyond simple design can be like opening Pandora’s Box unless you really know what you’re doing.

I’ve recorded a set of video tutorials that begin with basic MDX created using the graphical MDX Query Designer and then move to hand-written MDX queries and more advanced features.  Each tutorial is about 24 minutes in length.  The focus of these presentations is to show you how to use MDX in Reporting Services and doesn’t cover MDX language essentials.  If you need help getting started with the MDX query language, I recommend that you view Chris Webb’s MDX training on Project Botticelli.

These tutorials include:

1.Using the MDX Query Builder to generate queries & parameters

  • Examining the MDX query
  • Understanding parameter mapping

2.Hand writing MDX Queries

  • Adding parameters
  • Creating parameter list queries
  • Manual parameter mapping

3.Enhancing a Report

  • Creating cascading parameters
  • Updating a hand-written MDX query

These examples use the SSAS multidimensional sample database.  You can download the AdventureWorks Multidimensional Models SQL Server 2012 databases from the CodePlex site here.  Follow the directions to install/restore the relational data mart, the SSAS multidimensional project and then process the database from SSDT.  In full screen view, use the HD option.

Tutorial 1 – Using the MDX Query Builder to generate queries & parameters

Tutorial 2 – Hand writing MDX Queries

Tutorial 3 – Enhancing a Report

Digg This

Actions

Information

5 responses

27 06 2014
Ketan

Perfect….

4 02 2014
การทำ seo

This is a topic that’s near to my heart… Take care! Exactly where are your contact
details though?

6 02 2014
Paul Turley

Oh, sure. I’ll reply with that and all of my credit card numbers and SSN! Stay there and I’ll be right back…

3 02 2014
Paul Turley

You know, I usually just mark these comments as SPAM and get rid of them the moment that they’re posted to my blog but this comment was so entertaining that I had to leave it for the rest of you to enjoy. I’m not sure exactly what these dorks are trying to sell but it sounds like they’re offering to give away some crack to go with it. None for me, thanks.

3 02 2014
http://www.youtube.com/watch?v=EFyxct83ROs

Downloading Cube world usually expenses cash. I will supply you Dice World total
edition which you can obtain here for totally free.
Sure you will be ready to enjoy Cube Planet in a couple of minutes listed here
for free of charge, all you have to do is down load Dice Entire
world with the url supplied below. We included Dice Entire world crack so right
after you install Dice World Alpha, you can engage in it instantly.

Dice Planet is a 3D motion RPG type recreation that is manufactured/developed by Wollay and his spouse.
Cube Planet was started out in June 2011 and now, the Alpha variation is out previously.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




Follow

Get every new post delivered to your Inbox.

Join 272 other followers

%d bloggers like this: