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.
 
Search WWH ::




Custom Search