Database Reference
In-Depth Information
22.
From the To o l b o x tab of the Insertable Objects pane, drag a Data Item object into the
Data Items pane.
The Data Item Expression dialog box is displayed.
23.
Using items from the Data Items tab of the Av a i l a b l e C o m p o n e n t s pane, add the fol-
lowing expression in the Expression Definition pane:
[Return quantity] / [Quantity]
24.
Va l i d a t e t h e e x p r e s s i o n a n d c l i c k OK to close the dialog box.
25.
In the Properties pane, change the Name property to Return/Ship Ratio and change
the Aggregate Function property to Calculated .
26.
From the Run menu, select View Tabular Data to test your query.
27.
Click OK to dismiss the warning message and, when prompted, expand Employee by
region and select Americas .
Match your results to those shown in Figure 2.13.
28.
Close IBM Cognos Viewer to return to your report design.
Figure 2.13
Returned/shipped ratio query results
 
Search WWH ::




Custom Search