Databases Reference
In-Depth Information
Hierarchies and Levels
Hierarchies (also called multi-level hierarchies) are created from attributes of
a dimension. Each multilevel hierarchy contains one or more levels, and each
level is an attribute hierarchy. Based on the attributes of the Geography di-
mension you created, the logical hierarchy to create would be Country-State-
City-Dim Geography. Do not expand any of the attributes, stay at the highest
level for now. You can create this hierarchy using the following steps:
1. Drag and drop the attribute English Country Region Name from the
Attributes pane to the Hierarchy and Level pane. This creates a
multi-level hierarchy called Hierarchy with one level English Country
Region Name. This level actually corresponds to Country. Hence re-
name the "English Country Region Name" to "Country" by right click-
ing on the attribute within the multi-level hierarchy and selecting "Re-
name."
2. Drag and drop State Province Name from the Attributes pane to the
Hierarchy pane such that the State Province Name attribute is below
the Country in the multi-level hierarchy designer.
Rename "State Province Name" to "State-Province" by right clicking
on the attribute and selecting "Rename." Drag and drop attributes
City and Dim Geography attributes to the multi-level hierarchy in that
order so that you now have a four level hierarchy Country-State-City-
Dim Geography.
3. The default name of the hierarchy you have created is Hierarchy. Re-
name the hierarchy to Geography by right-clicking the name and se-
lecting Rename (see
Figure 5-16
). You can also rename the levels of
the Geography hierarchy by selecting each attribute and changing its
name value in the Properties pane.
Search WWH ::
Custom Search