Reporting Services - Professional SQL Server Analysis Services 2005 with MDX - page 933

Summary
In this chapter you discovered that Integration Services isn't the only stellar ex-
ample of product feature integration for enterprise business intelligence soft-
ware. Indeed, Microsoft's Reporting Services provides an awesome platform to
round out the business intelligence lifecycle. Specifically, this chapter covered
three scenarios; first, there was an introduction to Reporting Services by way
of building a report on a relational database. Then, you created a report on top
of a UDM, which showed some of the great integrated features of Reporting
Services such as drag-and-drop-based query generation and retrieving dimen-
sion and cell properties for inclusion in a report. You learned some of the key
enhancements in Reporting Services 2005 such as custom aggregates, re-
trieving extended properties, and the ability to manage report servers and
setup security for your reports. Finally, you learned to create a report model
from Analysis Services database and to generate ad-hoc reports using the Re-
port Builder application. If you need an in depth understanding of Reporting
Services 2005 we recommend you read the topic Professional SQL Server
2005 Reporting Services by Paul Turley, et al. (Wiley, March 2006).