Database Reference
In-Depth Information
5.
In the
Av a i l a b l e C o m p o n e n t s
pane, expand the
Employee by region
dimension within
the
Returned items
namespace.
COGNOS 8 NOTE
The
Employee by region
dimension is called
Employee (by region)
.
6.
Drag the
Employee by region
hierarchy into the
Expression Definition
pane.
7.
In the
Expression Definition
pane, add
->?Selected Location?
after the hierarchy.
8.
Add
item(
before the expression and
, 0)
after it.
The Expression should look like the following:
item (
[Returned items].[Employee by region].[Employee by region]
->?Selected Location?, 0)
9.
Click the
Va l i d a t e
button and then
OK
if there are no errors.
10.
In the
Properties
pane for the Data Item, change the
Name
property to
Location
.
11.
Change the
Aggregate Function
property to
None
.
12.
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 another
Data Item
object
into the
Data Items
pane.
13.
In the
Expression Definition
pane, create the following expression:
children( [Location] )
14.
Click the
Va l i d a t e
button and then
OK
if the validation returned no errors.
15.
In the
Properties
pane for the Data Item, change the
Name
property to
Sub-location
.
16.
Change the
Aggregate Function
property to
None
.
17.
In the
Source
tab of the
Insertable Objects
pane, drag the
Reason description
level
from the
Returned reason
dimension and the
Returned reason
hierarchy into the
Data
Items
pane in the work area.
COGNOS 8 NOTE
The
Reason description
level is called
Return reason
in IBM Cog-
nos 8 BI.
18.
Expand the
Returned items
measure dimension.
19.
Drag
Return quantity
into the
Data Items
pane.
20.
Expand the
Sales
namespace and the
Sales fact
measure dimension.
21.
Drag
Quantity
to the
Data Items
pane.