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




Custom Search