Databases Reference
In-Depth Information
2.
In the Properties pane, scroll down to the Source. In the drop-down box of the
NameColumns
property, select (new) and choose a new column in the Object Binding
dialog box.
Working with Hierarchies
When an end user connects to the server, typically he will see list of hierarchies and a
list of the levels in each hierarchy. From these lists, he can choose what sort of data he
wants to view.
There are two types of hierarchy in Analysis Services: attribute hierarchies and user hierar-
chies.
An attribute hierarchy is a hierarchy that contains a single level with the same name as
the attribute it is based on. Attribute hierarchies provide you with the flexibility to arrange
a report in a number of ways. For example, you can place a
Gender
level from the
Gender
attribute hierarchy on top of the
Age
level from the
Age
attribute hierarchy.
You are going to pay a price for this flexibility. If the only hierarchies you have in your
dimension are attribute hierarchies, you need to define ways to drill down from one level
to another. Otherwise, the performance of your system will be significantly degraded.
For the attributes that are not queried often, we recommend that you set the
AttributeHierarchyOptimizedState
property to
NotOptimized
.
To Hide an Attribute Hierarchy from the End User
1. Select the attribute in the Attributes pane of the Dimension Editor.
2. In the Properties pane, change the attribute property
AttributeHierarchyVisible
to
False
.
User hierarchies are the hierarchies you create in your dimension by dragging and drop-
ping attributes into the Hierarchies and Levels pane in the Dimension Editor. (You can
accomplish the same thing by editing the DDL.) Go back to Figure 9.8 to see the
Customer
dimension with a single hierarchy (
Customers
). The hierarchy contains levels, which we
created by dragging attributes into the hierarchy.
There are two types of user hierarchies: natural hierarchies and unnatural hierarchies. See
Chapter 5, “Dimensions in the Conceptual Model,” for details about natural and unnat-
ural hierarchies.
In a natural hierarchy, every attribute is related to its parent attribute in the hierarchy. An
attribute relationship object points to the parent of an attribute. In our example of the
Customers
hierarchy in Figure 9.9, you see the
City
attribute is related to the
State
Province
attribute.
Search WWH ::
Custom Search