Attribute Member Keys - Pt II: Composite Keys
In this article we will examine:
- A review of the three attribute usage types that we can define within each containing dimension.
- A review of the nature of the attribute member key and its role in meeting the primary objectives of business intelligence.
- A review of the role of the attribute member key from a technical perspective, including its purpose within its containing dimension within Analysis Services.
- A discussion of the differences between simple and composite keys, and an explanation as to why composite keys are sometimes required to uniquely identify attribute members.
- A review of the Properties associated with a composite key, based upon the examination of a representative dimension attribute within our sample UDM.
Tags: design