A report may contain data from many different data sources, and these
sources may be relational, OLAP, XML, or a variety of other sources, but each
Figure 10-4 The Dataset dialog box is where developers choose the data source to use,
set parameters, and more.
C h a p t e r 1 0 : S Q L S e r v e r R e p o r t i n g S e r v i c e s 323
dataset can relate to only a single data source. The command type for a dataset tied
to an Analysis Services data source can only be of type Text, although relational
sources can present other options. Finally, there is a box for the query string. At
this point, the developer is certainly free to start typing in the appropriate MDX
statement, but often this box is left blank and the query is designed using the
graphical query builder tool that will be examined next. Note too that there are a
number of tabs along the top of the Dataset dialog, some of which will be examined
during the chapter.
Assuming that the developer has set only the options shown in Figure 10-4,
clicking the OK button returns her to the report??™s Data tab with a designer loaded.
Actually, there are two views for the query designer: one is the design view, as
shown in Figure 10-5, and the other is simply a view of the text of the query
with a results pane below it. Flipping back and forth between the two views is
accomplished by clicking the Design View button, which is the right-most button to
the right of the Dataset drop-down list box.
When working with cubes, it??™s easy at this point to construct a query simply
by dragging and dropping items from the Metadata tab to the main work area of
the Query Designer.
Pages:
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411