More Exposure to Settings and Properties in Analysis Services Attribute Relationships

This article continues the overview of Attribute Relationships in Analysis Services, which we began in Introduction to Attribute Relationships in MSSQL Server Analysis Services, and continued in Attribute Relationships: Settings and Properties. Both this article and its predecessor extend the examination of the dimensional model that we began in Dimensional Model Components: Dimensions Parts I and II. After taking up various additional components of the dimensional model in subsequent articles, we performed hands-on exploration of the general characteristics and purposes of attributes in Dimensional Attributes: Introduction and Overview Parts I through V. We then fixed our focus upon the properties underlying attributes, based upon the examination of a representative attribute within our sample cube., extending our overview into attribute member Keys, Names and Values.

This article continues the focus upon attribute relationships, which define the possible associations between attributes, including a discussion surrounding why these relationships are important, and how they define the properties of association that a given attribute has with other attributes. Our concentration here will be to continue the detailed examination of the properties underlying attribute relationships that we began in Attribute Relationships: Settings and Properties, along with a review of the respective settings associated with each property, based upon attributes of additional representative dimensions within our sample UDM.