Build Ad hoc Reporting Solutions with Microsoft SQL Server 2005 Report Builder and Analysis Services
This paper introduces SQL Server 2005 Report Builder and demonstrates how to build an end-to-end ad hoc reporting solution for enterprise customers using Report Builder and SQL Server 2005 Analysis Services OLAP. We also highlighted a few product limitations as well as enterprise considerations. It is based on a real world implementation by Microsoft Business Intelligence Center of Excellence.
Designing an Analysis Services OLAP Cube
Building a Report Model
Deploying a Report Model to a Report Server
Authoring Ad-hoc Reports Using Report Builder
Many organizations have adopted Microsoft SQL Server Reporting Services and Analysis Services OLAP as part of their business-intelligence platform. SQL Server 2005 Reporting Services introduces a new end-user product, Report Builder, that enables business users to create ad-hoc reports based on information stored in both relational and OLAP data stores.