Database Reference
In-Depth Information
4.
From the
Source
tab of the
Insertable Objects
pane, expand the
Products
dimension
and the
Products
hierarchy within the
Returned items
namespace.
5.
Drag the
Product line
level into the
Data Items
pane in the work area.
6.
Expand the
Time
dimension and the
Time
hierarchy.
7.
Drag the
Ye a r
level into the
Data Items
pane in the work area.
8.
Expand the
Return reason
dimension and the
Return reason
hierarchy.
9.
Drag the
Reason description
level into the
Data Items
pane.
10.
Expand the
Returned items
measure dimension.
11.
Drag
Return quantity
into the
Data Items
pane.
12.
From the
Run
menu, select
View Tabular Data
to test your query.
Yo u r r e s u l t s s h o u l d r e s e m b l e w h a t 's s h o w n i n F i g u r e 6 . 3 0 .
13.
Close
IBM Cognos Viewer
to return to your report design.
Figure 6.30
Returns by product line query results
Step 7: Set Up the Shipping Volume by Month Query
This query will retrieve all the months in the selected year and the expected and actual shipping
volumes.
1.
In the
Explorer Bar
, mouse over the
Query Explorer
tab and select the
Queries
folder.
2.
Rename
Query3
to
Shipping_Volume_by_Month
.
3.
Double-click on the query to open the query definition.