|Build Ad hoc Reporting Solutions with Microsoft SQL Server 2005 Report Builder and Analysis Services|
|Written by Tian Ying He, Carolyn Chau|
|Wednesday, 21 November 2007 16:38|
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.
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.