Take MDX to the Next Level in SSRS

We will be at Moffett Towers in Sunnyvale for this meeting only.  Our usual location at the MTC is under construction.

Reporting Services is a powerful tool that can make designing reports a snap...most of the time. But every once in a while you have to format a report very specifically, and that starts with your data query.  In this session, you'll learn how to use named sets, dummy members, and other MDX tricks to craft your queries in a way that allows you to conquer the trickiest report layouts.

We'll go beyond the basics of MDX in the context of solving layout problems in Reporting Services. This is predominately an MDX session, so if you want to see the full potential of this great language, this session is for you. There will be many demos of queries and reports to help you understand how the various query elements interact and work and solve real world problems.

You'll learn

  • How to use the with clause of an MDX query
  • How to create calculated measures and members
  • How to create and use named sets
  • How to use dummy members to structure report datasets for easier report development
  • How to use some really cool MDX functions to solve common query problems!

Speaker Erika Bakse of Symmetry Corporation

Erika has helped develop training curricula for use of the various SQL Server business intelligence technologies and is a contributing author of Microsoft SQL Server 2008 Reporting Services Step by Step as well as a co-author for Microsoft SQL Server Reporting Services 2012 with Stacia Misner.

Erika's Twitter handle is @BakseDoesBI She is a Microsoft Certified IT Professional – BI, and a Microsoft Certified Technology Specialist – BI.

 

Join or login to comment.

  • Suresh B.

    I missed a good session. Hope I could make it next time.

    March 8, 2013

  • F. Paul W.

    For me this was a great intro to the subject. We always prefer to shift complex report calculations over to the SQL view or stored procedure. MDX takes this principle a step further and helps with shifting tricky categories into MDX sets and groupings.

    March 8, 2013

  • F. Paul W.

    Challenging to find in the dark. Without bing maps I 'd never found it.

    March 8, 2013

  • Mignon E

    Great topic, would love to see it in the north bay!

    March 6, 2013

Our Sponsors

People in this
Meetup are also in:

Create your own Meetup Group

Get started Learn more
Rafaël

We just grab a coffee and speak French. Some people have been coming every week for months... it creates a kind of warmth to the group.

Rafaël, started French Conversation Group

Start your Meetup today

Act now and get 50% off.
Until February 1.

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy