Database Reference
In-Depth Information
set to Automatic for each of the data items. We want to remove the duplicate records
without affecting the inventory numbers.
7.
Close
IBM Cognos Viewer
to return to your report design.
8.
Click
City
and Shift-click
Product
to select the first three data items in the query.
Change the
Aggregate Function
property to
None
.
9.
Click
Closing inventory
and change the
Aggregate Function
property to
To t a l
.
10.
From the
Run
menu, select
View Tabular Data
to test your query. Click
OK
to dismiss
the warning message. Figure 4.6 shows the two details merged into one.
Figure 4.6
Query with merged results
By doing a union query, we are not changing the relationships defined by the modeler
between the
Products
data and the
Inventory
numbers.
Step 6: Create the List Report
Now that the queries have been built and tested, we will create the report using that query. The
report will perform page breaks for every city and list product type, product, and closing
inventory.