Developing Reporting Services Reports Against Analysis Services (Mark Frawley)

in SQL Server

Thursday, May 12, 2011, 6:00 PM to 8:30 PM

This presentation is primarily aimed at developers already familiar with Reporting Services against non-cube sources, and secondarily at developers familiar with Analysis Services but not Reporting Services.  I will demonstrate using Analysis Services as a report data source, in the process showing how this is in many ways a lot like sourcing from a relational source – good news in terms of leveraging what you already know.   The bad news, which those familiar with Analysis Services will appreciate, is that Reporting Services treats multi-dimensional cube data much like relational data – that is, it flattens it and has various other restrictions – which makes it difficult to exploit the full potential of a cube.  We will explore this perspective and look at some workarounds.

Mark Frawley is a BI architect at Tallan, Inc and has been involved in all aspects of data warehousing, OLAP and BI design and implementation for the past 15 years, with a focus on the Microsoft BI stack for the last eight. He is the author of the chapter on Data Warehousing in the Microsoft Press book Programming SQL Server 2008 by Lobel, Brust and Forte. An ex-electrical engineer, he feels fortunate to have found his way into this fascinating field which Microsoft is doing so much to advance.

Leave a Comment

Previous post:

Next post: