Databases Reference
In-Depth Information
attributes. You can see the related attributes of the key attribute Dim Geo-
graphy in the tree view of
Figure 5-14
. Just choose the view that best suits
you to visualize and design your dimension easily. You can toggle between
the different views by right-clicking in the Attributes pane and selecting the
view type you desire, as shown in
Figure 5-14
.
Figure 5-15
shows the List view and Grid view of the attributes shown in
Fig-
ure 5-14
. The List view provides you a concise view where the attributes pane
is below the Hierarchies and Level pane. The List view is useful when you
have a lot of multi-level hierarchies in the dimension. Since you get a wider
area for the hierarchies and levels pane you get a visually optimized view
where you can see the attributes and hierarchies. In the Grid view you can
see all the attributes with a subset of properties for each attribute. Each prop-
erty specified in the Grid view is an editable drop-down list box so you can
change the properties in this view. All the properties shown in the Grid view
are also a part of the Properties window.
Figure 5-15
If you are aware of a one-to-many relationship between attributes, we highly
recommend that you specify this relationship in the Dimension Designer as a
related attribute. Specifying the member property helps improve query per-
formance as well as changing the aggregation design so as to include the at-
tributes that are part of a hierarchy. You learn more about this in
Chapter 12
.
Search WWH ::
Custom Search