You
can define a join between a dimension and a measure dimension when
the level of a join does not match the level of the fact table. You
must define the correct join to avoid double counting data from the
fact table.
Procedure
- From the Project Explorer tree,
select the dimension or measure dimension for which you want to define
a join.
- Select the Relationships tab.
- Click New Relationship
,
select the dimensions or measure dimensions that you want to join,
then click OK.
- For each dimension or measure dimension, click Edit,
and select the Joins tab.
- Specify the join by relating columns in the dimension to
columns in the measure dimension.
- Specify the relationship operator.
- If the join is at a higher grain than the lowest level
of the dimension, clear the Join is at the lowest level
of detail for the dimension check box.
Important: Note: IBM® Cognos® Cube Designer cannot automatically
detect that a join is at a higher grain than the lowest level of a
dimension.