Databases Reference
In-Depth Information
FIGURE 9.9
Define attribute relationships in the Dimension Editor.
To create a new attribute relationship object, in the Attribute Relationship tab drag one
attribute on top of another. The attribute that you want to drag to another should be the
“more granular” (in other words, the attribute that will appear higher in the level hierar-
chy). For example, drag the
City
attribute on top of
State Province
attribute to create a
relationship.
By default, Analysis Services creates the
RelationshipType
property as
Flexible
. You can
see a relationship's properties in the Properties pane if you select the relationship in the
main pane. Change the property to
Rigid
if you are sure that the members of the
City
attribute are not going move to another state. Specifying a
Rigid
relationship guarantees
that an aggregation based on attributes with rigid relationships will not get dropped after
an incremental update of the dimension.
If you made a mistake and dragged a wrong attribute and created an unwanted relation-
ship, you have an option to delete an attribute relationship by selecting an arrow in a flow
chart diagram in the main drawing pane or by selecting a relationship in the Attribute
Relationship pane in the lower middle.
In many cases, as in our example, you want the
Name
column and the
Key
column to be
different. We have already done this for the
Customer
attribute in the
Customer
dimen-
sion. Here's how we did it:
1.
Select the
Customer
attribute.
Search WWH ::
Custom Search