Database Reference
In-Depth Information
2.
From the
To o l b o x
tab of the
Insertable Objects
pane, drag a
Query Calculation
object
into the
Data Items
pane of the work area.
A dialog box is displayed.
COGNOS 8 NOTE
In the prior version, IBM Cognos Report Studio has a Toolbox
object called
Calculated Member
, which would reduce the number of steps required to
create the
Selected Time
data item. In this case, drag a
Calculated Member
object into
the
Data Items
pane. Skip the next step and continue with step 4.
3.
Ve r i f y t h a t t h e
Calculated member
radio button is selected.
4.
In the
Name
field, type
Selected Time
.
5.
In the
Hierarchy
drop-down list, select the
Time
hierarchy from the
Returned Items
namespace.
6.
Click
OK
and the Calculated Member Expression dialog box is displayed.
7.
In the
Expression Definition
pane, type the following function:
item ( [Time], 0 )
This function returns the first member of a set. Since
Time
is selected as a single item,
there will be only one item in the set.
8.
Click
Va l i d a t e
and
OK
if the validation returned no errors. If prompted, expand
Products
and select
Camping Equipment
. Also, expand
Time
and select
2005
.
9.
In the work area, click
Reason description
to select it.
10.
In the
Properties
pane, double-click the
Set Sorting
property to open the dialog box.
11.
In the Set Sorting dialog box, change the
Sort type
to
Descending
.
12.
In the
Sort by
section, select the
Intersection (tuple)
radio button and click the ellipsis
for the selection.
The Members dialog box is displayed.
We will select the newly created
Selected Time
member and
Returned items
measure
for the intersection values.
13.
From the
Av a i l a b l e m e m b e r s a n d m e a s u re s
pane, expand
Sales and Marketing
(analysis)
and
Returned Items
namespaces.
14.
Drag
Return quantity
from the
Returned items
measure dimension to the
Intersection members and measures
pane.
15.
From the
Calculated members and measures
tab in the
Av a i l a b l e m e m b e r s a n d m e a -
sures
pane, drag
Selected Time
to the pane on the right.