In a simple example of how to work with a relational report, this walkthrough will
cover the sales details for a product category within a country for a given year. Each
individual order for both the product category and country will be listed for that year,
so the report may be quite large.
The first step is to create a data source that accesses a relational database, which
in this case is the relational data warehouse for the Adventure Works Company.
This database, AdventureWorksDW, is the source for the cube used in most of
the examples throughout this book. Creating the data source is done as before, by
right-clicking on the Shared Data Sources folder and then selecting Add New Data
Source. The Shared Data Source dialog box opens and defaults to Microsoft SQL
Server connection, which is correct in this scenario. After naming the data source,
the developer can click on the Edit button to open the Connection Properties dialog
box, as seen earlier. After entering the server name, the developer should choose the
AdventureWorksDW database. Figure 10-14 shows what the connection might look
like, with the only difference between this example and that of the reader being the
server name.
The next step in the process is to create a new report. Once again, the developer
should right-click on the Reports folder and then choose Add, New Item, and
Report (note that once again, the wizard is not being used.) Once the report has
been created, the developer goes to the Data tab and chooses New Dataset from the
Dataset drop-down list box.
Pages:
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426