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.
- 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.