Customizing advanced attribute properties

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.

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 leftmost pane of the dimension editor in SSDT.
  2. Set ...

Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.