| 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 IntroductionMany 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. |
Top Rated
- MS Document: Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables
- SQL Server 2008 White Paper: Analysis Services Performance Guide
- Functionality & Performance Testing Analysis Services 2005 with Teradata v12
- Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services
- Building Ad-hoc Reporting Solutions with SQL Server 2005 Report Builder and Analysis Services OLAP
- MS Paper: 2007 Microsoft Office System Business Intelligence Integration with SQL Server 2005
- Configuring HTTP Access to SQL Server 2005 Analysis Services on Microsoft Windows XP
- Why Local Cube Creation with ASSL is Superior to Local Cube Creation with the Create Global Cube Com
Build Ad hoc Reporting Solutions with Microsoft SQL Server 2005 Report Builder and Analysis Services
