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.
 
 
Search WWH ::




Custom Search