Database Reference
In-Depth Information
28.
From the
Run
menu, select
View Tabular Data
to test your query. When prompted,
expand
Products
and select
Camping Equipment
. Also, select
Time
and click
OK
.
COGNOS 8 NOTE
The
Products
member is
Products (all)
, and the
Time
member is
Time dimension (all)
in IBM Cognos 8 BI.
The results of the query should resemble what's shown in Figure 2.21.
29.
Close
IBM Cognos Viewer
to return to your report design.
Figure 2.21
Product_Returns_by_Product query results
Step 3: Build the Crosstab Report
1.
In the
Explorer Bar
, mouse over the
Page Explorer
tab and select
Page1
.
2.
From the
Data Items
tab of the
Insertable Objects
pane, drag
Time Group
into the
Columns
area in the crosstab.
3.
Drag
Return quantity
into the
Measures
area of the crosstab.
4.
Drag
Product
into the
Rows
area of the crosstab.
5.
Drag
Product Details
into the
Rows
area below
Product
.