On the Dataset dialog box, the dataset is given a name, and the data source is
set to the data source just created (called AdvWorksDW in Figure 10-14). This
ensures that the data source is the relational database and not the cube, as used in the
previous example. At this point the developer could type in the SQL statement, but
clicking the OK button opens the dataset in query mode.
The default view for a relational query is to show just a blank area at the top
and a grid at the bottom. The blank area holds the text of the SQL statement and
the grid will show the results if the query is executed. It is sometimes easier to use
the graphical query builder, and the view can be switched back and forth using the
336 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
Generic Query Designer button, which switches between the text box and a graphical
display to which the developer can add tables and select fields.
For this particular query, there are a number of tables that need to be added.
Right-clicking in the upper pane of the query designer opens a pop-up menu with the
option Add Table. Selecting this option opens a list of the tables and views in this
particular database. For this example, the developer chooses the following tables:
FactInternetSales
DimCustomer
DimTime
DimGeography
DimProduct
DimProductCategory
DimProductSubcategory
Figure 10-14 This is a shared data source that connects to a relational database.
Pages:
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427