Database Reference
In-Depth Information
15.
In the
Av a i l a b l e C o m p o n e n t s
pane, expand the
Products
dimension.
16.
Drag
the
Products
hierarchy from the
Av a i l a b l e C o m p o n e n t s
pane into the
Expression Definition
pane.
COGNOS 8 NOTE
The
Products
dimension and hierarchy are called
Product
.
17.
In the
Expression Definition
pane, add
->?Selected Product?
after the hierarchy.
The Expression should be this:
[Returned items].[Products].[Products]->?Selected Product?
18.
Click
Va l i d a t e
and then
OK
if there are no errors.
19.
In the
Properties
pane, change the
Name
property to
Product
and change the
Aggregate Function
property to
None
.
Now we will show all the product information below the selected item, as well as the
selected item.
20.
In the
To o l b o x
tab of the
Av a i l a b l e C o m p o n e n t s
pane, drag a
Data Item
object into the
Data Items
pane.
The Data Item Expression dialog box is displayed.
21.
In the
Expression Definition
pane, type the following function:
descendants ( [Product], 1, self after )
22.
Click
Va l i d a t e
and
OK
if the validation returned no errors.
23.
In the
Properties
pane, change the
Name
property to
Product Details
and change the
Aggregate Function
property to
None
.
24.
In the
Source
tab of the
Insertable Objects
pane, expand the
Return reason
dimension
and the
Return reason
hierarchy.
25.
Drag the
Reason description
level into the
Data Items
pane in the work area.
COGNOS 8 NOTE
The
Reason description
level is named
Return reason
in IBM
Cognos 8 BI.
If you click on the
Return reason
data item, you will see in the properties that you cre-
ated a level set that displays all Return reason members.
26.
In the
Source
tab of the
Insertable Objects
pane, expand the
Returned items
measure
dimension.
27.
Drag
Return quantity
into the
Data Items
pane.