Databases Reference
In-Depth Information
tribute directly corresponds to a column in the relational table. Therefore
when the dimension is part of UDM that is used for relational reporting, attrib-
utes are selected from the UDM for the corresponding relational column. The
Attributes pane in the Dimension Designer shows all the attribute hierarchies
of the dimension. The default view of all the attributes within the Attributes
pane window is called the Tree view as shown in
Figure 5-14
. The two addi-
tional views supported in the Dimension Designer are the List view and the
Grid view. These views show the attributes and associated properties in dif-
ferent views. We have seen the Tree view to be the most flexible view in the
Dimension Designer. In the Tree view you can see the attributes along with
the member properties. Member properties are attributes within the same di-
mension that have a one-to-many relationship with the current attribute. For
example, if you have the attributes Country, State, and City, you have one-to-
many relationships between country and state, as well as between state and
city. Member properties are also referred to as related attributes because
these attributes have a one-to-many relationship between them.
Figure 5-14
Each dimension has to have at least one attribute that is defined as the key
attribute. By definition, the key attribute has a one-to-many relationship with
every attribute in the dimension. The Dimension Wizard automatically estab-
lishes relationships, such that all attributes of the dimension are related to key
Search WWH ::
Custom Search