Build Ad hoc Reporting Solutions with Microsoft SQL Server 2005 Report Builder and Analysis Services-SSAS

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.

Contents

Introduction
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
Publishing Reports
Conclusion
More Information

Introduction

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.