Database Reference
In-Depth Information
4.
From the Source tab in the Insertable Objects pane, drag the following query items from
the Product forecast (query) namespace into the Data Items pane in the work area:
Ye a r from Time
Month from Time
City from Branch
Expected volume from Product forecast fact
COGNOS 8 NOTE
The Time query subject is called Time dimension .
5.
In the Data Items pane, click City to select it.
6.
In the Properties pane, change the Name to Branch .
7.
Change the Pre-Sort property to Sort ascending .
8.
From the Run menu, select View Tabular Data to test your query. The query results
should match what's shown in Figure 2.28.
9.
Close IBM Cognos Viewer to return to your report design.
Figure 2.28
Expected_Volume_by_Branch query results
Search WWH ::




Custom Search