SSAS Papers Building Ad-hoc Reporting Solutions with SQL Server 2005 Report Builder and Analysis Services OLAP
Building Ad-hoc Reporting Solutions with SQL Server 2005 Report Builder and Analysis Services OLAP
User Rating: / 1
PoorBest 
Written by Tian Ying He, Carolyn Chau   
Tuesday, 01 May 2007 00:00

This paper introduces Microsoft 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 Microsoft SQL Server 2005 Analysis Services OLAP. We also highlight 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.

Read more...