Once the query is built, the developer can click on the Layout tab to begin the
layout of the report itself, which includes mapping data elements to the page.
Figure 10-5 All levels of the Customer Geography hierarchy are shown in the result set
due to Reporting Service??™s flattening of the data.
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 325
By default the design surface of the report is blank and elements from the Toolbox
can be placed on it. Oftentimes with OLAP data, the matrix control is used. This
certainly isn??™t the only control that can be used and many reports of OLAP data
are done using the table control, but the matrix is the most popular for dealing with
multidimensional data.
The matrix starts out with a single column, a single row, and a single cell for the
data. Normally, the measure will go in the Data box, and additional boxes can be
added if there are multiple measures. The developer can simply drag the measure
from the Datasets window and drop it on the Data box in order to tie these two
elements together. Similarly, dragging the Country field from the Datasets window,
dropping it on the Rows, and then dragging Calendar_Year and dropping it on the
Columns will set up the matrix to do some simple reporting.
Figure 10-6 shows what the matrix looks like after the fields from the dataset
have been tied to it, and the columns have been expanded to show all the text. Notice
that the values all start with an equal sign; this is because nearly every property
Figure 10-6 This is the matrix control, which contains a single measure and a single level
from two different dimension hierarchies.
Pages:
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414