Database Reference
In-Depth Information
5.
From the
Source
tab of the
Insertable Objects
pane, expand the
Employee expense
(query)
namespace.
6.
Expand the
Organization (consolidated)
query subject, and drag
Organization name
into the
Data Items
pane in the work area.
COGNOS
8
NOTE
The
Organization
(consolidated
)
query
subject
is
called
Organization
.
7.
From the
Source
tab of the
Insertable Objects
pane, drag the following items from the
Employee training (query)
namespace into the
Data Items
pane in the work area:
•
Current Manager
and
Employee name
from
Employee by manager
•
Date
from
Time
•
Course name
from
Employee training
•
Course days
and
Course cost
from
Employee training fact
COGNOS 8 NOTE
The
Time
query subject is called
Time dimension
.
8.
In the
Data Items
pane, click
Organization name
and Shift-click
Date
to select the
first four items in the query.
9.
In the
Properties
pane, change the
Pre-Sort
property to
Sort ascending
.
10.
From the
Source
tab of the
Insertable Objects
pane, drag
Ye a r
from the
Time
query
subject into the
Detail Filters
pane of the work area.
11.
In the Expression Definition pane, add
=2007
after the data item.
The Expression should be this:
[Employee training (query)].[Time].[Year] = 2007
12.
Click
Va l i d a t e
and then
OK
if there are no errors.
13.
From the
Source
tab of the
Insertable Objects
pane, drag
Month
from the
Time
query
subject into the
Detail Filters
pane of the work area.
14.
In the Expression Definition pane, add
= 'April'
after the data item.
The Expression should be as follows:
[Employee expense (query)].[Time].[Month] = 'April'
15.
Click
Va l i d a t e
and then
OK
if there are no errors.
16.
With the month filter selected, change the
Usage
property to
Optional
in the
Properties
pane.
