Databases Reference
In-Depth Information
Turn
Off
AttributeHierarchy
for
Member
Properties
Some attributes are not relevant to data analysis per se, which means
user queries will never pivot on those attributes. Still, it is useful to dis-
play and use those attributes as member properties. Consider the "birth
date" attribute; although customer queries may never break down fact
data by birth date, customer birth date might be displayed next to cus-
tomer names in reports, perhaps as a sorting criteria for listing custom-
ers. You can turn off the AttributeHierarchyEnabled property for "birth
date" to tell the Analysis Services not to build an attribute hierarchy
for this attribute, but keep it as a member property. This reduces the
time and space needed for dimension processing.
Figure 13-5
shows
the AttributeHierarchyEnabled property for a dimension attribute. If this
property is set to false for an attribute; you will not be able to browse
the hierarchy. Rather, you can query the attribute members as member
properties.
Figure 13-5
Search WWH ::
Custom Search