Database Reference
In-Depth Information
12.
From the
Run
menu, select
Run Report - HTML
to test your report. If prompted,
expand
Products
and select
Camping Equipment
. Also, expand
Time
and select
2005
.
The report output should have values similar to those shown in Figure 2.23.
Figure 2.23
Initial report results
Notice that the return descriptions are all listed in the same order. To improve the value
of the report, the Return descriptions should be sorted for each row and the selected time
period.
13.
Close
IBM Cognos Viewer
to return to your report design.
Step 4: Refine the Sorting on the Row Data
In the preceding query, we created three group sets that work independently of one another. Now
you want to arrange the Return reasons in descending order based on the product information in
the row and the selected time period. To do this, we will define the set sorting to be a tuple (inter-
section) of the return reason, selected time, and quantity returned.
1.
In the
Explorer Bar
, mouse over the
Query Explorer
tab and select
Product_
Returns_by_Product
.
A tuple represents the intersection of members, so the
Time
set in the query needs to be
cast as a member before the set can be sorted by the selected time period.