Business Intelligence and Big Data with the Microsoft Stack, For Database Administrators, For Developers

SQW08 Serene Velocity: Reporting Services and Analysis Services Data


11:00AM - 12:15PM

Level: Intermediate

William Pearson

William E. Pearson III

Business Intelligence Architect and Founder

Island Technologies Inc.®

SSRS 2008, 2008R2 and beyond provide powerful capabilities to help us develop sophisticated reports from Microsoft SQL Server Analysis Services. Unfortunately, many of these features, such as the server aggregation function, are commonly ignored by report developers. The result: redundant work in the reporting layer. In this session, BI Architect and MVP Bill Pearson exposes ways to optimize reporting from SSAS by writing MDX that leverages, rather than replicates, what the cube is designed to do best.

You will learn:

  • How to perform an overview of Reporting Services for Analysis Services
  • The use of Multidimensional Expressions (MDX) in Reporting Services, focusing upon the challenges that accompany the use of the internal MDX query editor