Databases Reference
In-Depth Information
Figure 6-16
3. The cube editor identifies a default relationship through an attribute
between existing measure groups and the Geography dimension and
defines a relationship. If you go to the Dimension Usage page you
will see the relationship established by the editor as shown in
Figure
6-17
. This cube editor has established a regular relationship with the
attribute Dim Sales Territory with both the measure groups. The
BIDS detects there are columns named Sales Territory key in the di-
mension table Dim Geography as well as both the fact tables. Since
the column names are matching it establishes a regular relationship.
However if you look at the fact and dimension tables and the rela-
tionships in the DSV you will notice this is an incorrect relationship.
There exists an indirect relationship between Dim Geography dimen-
sion and Fact Internet Sales measure group through the Dim Cus-
tomer dimension. There is an indirect relationship between Dim Geo-
graphy dimension and the Fact Reseller measure group through the
Dim Reseller dimension. You need to define a reference relationship.
Search WWH ::
Custom Search