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