Databases Reference
In-Depth Information
You can set the relationship type between attributes in BIDS by doing the fol-
lowing:
1. Open the sample project Adventure Works DW.
2. Open the Customer dimension by double-clicking that dimension in
Solution Explorer.
3. In the attributes pane, click the key attribute Customer. Click on the +
sign to see all the attributes that are related to the key attribute.
4. Click any of the attributes under the key attribute such as Phone
number. If you look at the properties window you will see a Relation-
ship Type property as shown in
Figure 13-36
, which has the values
Flexible and Rigid.
Figure 13-36
5. Expand the user hierarchy Customer Geography and click the Coun-
try attribute relationship as shown in
Figure 13-37
. In the properties
window you will find that its relationship type is set as Rigid because
Search WWH ::
Custom Search