Database Reference
In-Depth Information
6.
In the
Detail
pane, click
Ye a r
so that Current year and Year are linked.
7.
Click
OK
to close the dialog box.
Now we will build the pie chart.
8.
From the
Data Items
tab, drag
Reason description
from the
Returns_by_Product_
Line
query into the
Series (pie slices)
drop zone of the pie chart.
9.
Drag
Return quantity
into the
Default measure
drop zone of the pie chart.
10.
Drag
Product line
into the
Categories (pies)
drop zone.
11.
Ve r i f y t h a t a n i t e m i n s i d e t h e p i e c h a r t i s s e l e c t e d i n t h e w o r k a r e a , a n d f r o m t h e
Data
menu, select
Master Detail Relationship
.
12.
Click
New Link
.
13.
Click
Ye a r
to filter the year by Current year.
14.
Click
OK
to close the Master Detail Relationship dialog box.
Now we can build the third object on the dashboard, the combination chart.
15.
From the
Data Items
tab, drag
Quantity shipped
from the
Shipping_Volume_by_
Month
into the
Series
drop zone of the combination chart.
This series will create a bar for the quantities shipped.
16.
Drag
Expected volume
into the second
Series
drop zone.
This series will create a line for the expected volumes.
17.
Click the icon for the third series and press the
Delete
key on the keyboard to remove it
since we do not need a series to show as an area chart.
18.
Drag
Ye a r
into the
Categories (x-axis)
drop zone.
19.
Drag
Month
as a nested item under
Ye a r
.
20.
Ve r i f y t h a t a n i t e m i n s i d e t h e c o m b i n a t i o n c h a r t i s s e l e c t e d i n t h e w o r k a r e a , a n d f r o m
the
Data
menu, select
Master Detail Relationship
.
21.
Click
New Link
.
22.
Click
Ye a r
to filter the year by Current year.
23.
Click
OK
to close the Master Detail Relationship dialog box.
24.
From the
Run
menu, select
Run Report - HTML
to compare the dashboard to what's
shown in Figure 2.6.
Looking at the report, there are a number of changes to make for the formatting to dis-
play the information correctly.
Also, the requestor wants to be able to display all of this on one screen of a monitor
using a 1024x768 resolution.
25.
Close
IBM Cognos Viewer
to return to your report design.