Analysis Services allows customizing a number of attribute properties. Discussing each property with their corresponding screenshots would make this chapter extremely lengthy. Therefore, we will discuss commonly used advanced properties here and mention other relevant properties elsewhere in the book. 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.
To set a dimension attribute's property, perform the following steps:
Click on the attribute you wish to customize in the list of attributes on the leftmost pane of the dimension editor in SSDT.
Set focus to the Properties window to see a list of all the properties for the selected attribute.
Pick the property you want to change and set its value as desired.
Note that you cannot modify any property that is grayed within the properties window. For...