BAADD .NET Developer User Group - Integrating SQL Server 2005 Reporting Services with SQL Server Analysis Services to Report Against CUBES May 31, 2006

Back in February, we showed how to integrate SSRS with ASP.NET applications and the primary areas to focus on. This month, we'll look at some of what you will need to understand in order to build reports against an Analysis Services CUBE from within reporting services.

These issues are the same whether running SSRS reports in ASP.NET, a Winforms application or directly from the built-in Reporting Services web application. This developer centric presentation will take a particular look at:

-An overview of all the pieces (Reporting Services, Analysis Services, Integration Services), and why you should care.
-Review of a simple CUBE and connecting it as a Data Source for SSRS - (Analysis Services vs SQL Server Engine)
-Building MDX queries as DataSets for your reports, and the challenges of MDX vs SQL
-Working with parameters (DataSet vs Report), and building picklists from Analysis Services vs SQL RDBMS extracts

Along the way we'll create a simple Reporting Project in Visual Studio 2005, build and deploy some simple reports (tabular and charts) to a reporting server.

Join us for networking, pizza, soft drinks and raffle items at the break.

About Don Robins
A business application developer since the mid-80's, and a graduate of Cornell University where he was first introduced to computers in 1975, Don's clients have included a wide range of industries. His technical skills also span a wide variety of development platforms and databases other than .NET and SQL Server, and include Lotus Notes/Domino, ColdFusion, Access, DB2, VB6 and Visual FoxPro. As one of the owners of Outformations, Inc. (a collaborative design and development practice,) he specializes in the design and delivery of custom data centric business solutions for the Windows desktop and Web platforms, often leveraging reusable application frameworks. He is currently president of the Bay Area Association of Database Developers (BAADD), and leader of the BAADD .NET Developers' User Group.

Pizza and sodas are served before the presentation, we'll have the usual collection of raffle prizes (though you must be present to win.)

Meetings are free for current ADD members, and $10 at the door for nonmembers. Annual dues are $75, and you can join at the door.


Event submitted by Eventful.com on behalf of baadd.