Accessing Cubes with Reporting Services
Reporting Services projects are created through BIDS with several types of projects
that can be created. Figure 10-1 shows the New Project dialog box containing three
templates specific to Reporting Services: Report Server Project Wizard, Report Server
Project, and Report Model Project. The Report Server Project Wizard template will
create a new Reporting Services project and then guide the user through setting up
the project and creating the first report. Subsequent reports can also be created by
walking through the wizard. While there is certainly nothing wrong with using the
wizard, after gaining some experience with Reporting Services many developers walk
through the creation process manually, as will be shown later on in this chapter.
The Report Model Project template guides the developer through the process of
creating a reporting model, which is an abstraction layer designed to make it easier for
Figure 10-1 The New Project dialog box shows that there are three different templates
that can be used to create Reporting Services projects.
320 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
end users to build their own reports. Many end users lack the knowledge of relational
databases necessary to understand the joins that are needed to produce the report they
are after. A report model can simplify the view of the underlying database in ways that
make it much easier for end users to work with as they create their reports.
Pages:
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407