Database Reference
In-Depth Information
Figure 2.3
Returned/shipped ratio query results
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.
COGNOS 8 NOTE
The
Reason description
level is called
Return reason
.
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 2 . 4 .
13.
Close
IBM Cognos Viewer
to return to your report design.
Step 6: Set Up the Shipping Volume by Month Query
This query will retrieve all the months in the last year in the database and the expected and actual
shipping volumes.