It??™s still possible to override
328 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
that format by changing the Format property of the subtotal, but in most cases
businesses will want the same format as the data it is totaling.
The reports shown in Figure 10-7 and Figure 10-8 are static, meaning that they do
not contain interactivity. For example, users cannot see the data at the quarter level
for each year, nor can they expand countries into the states or provinces that make up
those countries. Adding such interactivity to the report is examined next.
Adding Parameters
Adding parameters to a report is perhaps the easiest way to add interactivity that
allows users to perform some of the own simple analysis. The good news is that adding
parameters is relatively simple, but there are several ways to modify parameters so that
they are more effective and allow users to perform the analysis they need.
The first step in adding a parameter is to return to the Data tab. When the graphic
query designer is shown, there is an area above the data grid that allows for filters
Figure 10-8 The matrix now has subtotals added for both the rows and columns. Some
simple formatting has been applied to change the background color for the
row and header columns as well as the subtotals.
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 329
to be added. The developer can click on the Dimension drop-down box or drag the
dimension attribute or hierarchy from the Metadata tab and drop it on the Filters
area.
Pages:
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418