Report Portal

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.

Read more...

 

Tags: design

 

2007-2015 VidasSoft Systems Inc.