This page intentionally left blank
317
CHAPTER 10
SQL Server
Reporting Services
IN THIS CHAPTER
Creating Reports with Reporting Services
Summary
318 B u s i n e s s I n t e l l i g e n c e w i t h M i c r o s o f t O f f i c e P e r f o r m a n c e P o i n t S e r v e r 2 0 0 7
SQL Server Reporting Services is a server-based reporting tool that is included
with SQL Server. It can connect to many different data sources, including both
relational and OLAP stores. Reporting Services runs on a web server, which
means that no distribution is necessary for end users. One of the most important
features for our purposes is that Reporting Services includes functionality that allows
for analytics, albeit in a limited fashion. Reports can allow for items to be expanded
so that they show lower levels of detail, with one report linking to another to mimic
drill-down or cross-drill behavior. Not only can a report link to other reports, but it
can link to anything that can be viewed in the browser, which means that it can call
PerformancePoint dashboards, ProClarity Analytics Server views, and more.
Given that the focus of this book is on PerformancePoint Server and not
Reporting Services, this chapter will cover the analytic capabilities of Reporting
Services. It will specifically cover the ways Reporting Services can access data
from cubes and the ways that interactive reports can be created to allow end users to
perform analysis. For books dedicated to Reporting Services, check out Microsoft
SQL Server 2005 Reporting Services 2005 and Delivering Business Intelligence with
Microsoft SQL Server 2005, both by Brian Larson.
Pages:
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405