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