Database Reference
In-Depth Information
Figure 2.37
Shipping dashboard with exceptional data
17.
Expand
Ye a r
and select
2007
. Click
OK
to open the target report. The drill report is dis-
played and should look like what's shown in Figure 2.38.
Figure 2.38
Shipping dashboard with exceptional data
Now you can look for any trends by product lines that may have excessive returns.
18.
Close
IBM Cognos Viewer
to return to your report design.
If you would like to drill-through and send the year, you can add the
Ye a r
data item of
the query as a nested item in the Series (pie slices) region of the report.