Using Analysis Services 2005+ as a Source for Reporting Services 2005+ (Mark Frawley)

in SQL Server

Thursday, April 14, 2011, 6:00 PM to 8:30 PM


We’re really sorry to report that due to illness, Mark Frawley will not be able to present this month, so we need to cancel the meeting. We are working with Mark to reschedule this presentation for a future month.

Analysis Services as a multidimensional (cube) data source is unfortunately a second class citizen as a data source to Reporting Services compared to relational sources, even though they are both Microsoft offerings. It is still possible to leverage Reporting Services effectively against cube sources, but various workarounds and tricks are often necessary. We will review the limitations and the workarounds. Time permitting we will also review limitations and workarounds for other Microsoft cube-client offerings such as Excel Services and Performance Point which are crucial to be aware of as you architect your solution.

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: