SQL Server Analysis Services 2005/2008 articles,blogs,scripts,FAQs,tools,books

• 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...