Database Reference
In-Depth Information
Customizing
advanced
attribute
properties
Analysis Services allows customizing a number of attribute properties. Discussing
each property with their corresponding screenshots would make this chapter ex-
tremely lengthy. Therefore, we will discuss commonly used advanced properties here
and mention other relevant properties elsewhere in the topic. We will refer to relevant
dimensions available within the Adventure Works 2012 sample database so that you
can examine existing dimensions instead of having to define each one of them from
scratch.
How to do it...
To set a dimension attribute's property, perform the following steps:
1. Click on the attribute you wish to customize in the list of attributes on the left-
most pane of the dimension editor in SSDT.
2. Set focus to the
Properties
window to see a list of all the properties for the
selected attribute.
3. Pick the property you want to change and set its value as desired.
4. Note that you cannot modify any property that is grayed within the properties
window. For example, the
ProcessingState
and
ID
properties are read-only
and cannot be changed.
How it works...
The
AttributeHierarchyEnabled
property controls whether the attribute is en-
abled for browsing. Recall that the
Dimension Wizard
allowed specifying whether
each attribute should be enabled for browsing. The default value is
true
, which
means users will be allowed to browse the data. Additionally, if the attribute hierarchy
is not enabled (meaning that you set the
AttributeHierarchyEnabled
property
to
false
), you will not be able to include it in any of the user-defined hierarchies.
However, users can still query such attributes as member properties of other (en-
abled) attributes. An attribute that has a relationship with another attribute is known
as the member property. For example, the
e-mail address
attribute in the
Em-
ployee
dimension has
AttributeHierarchyEnabled
set to false, but it is related
Search WWH ::
Custom Search