Microsoft distributes Microsoft SQL Server 2008 R2 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 R2 fix release.
- You install Microsoft SQL Server 2008 R2 Analysis Services (SSAS) on a computer.
- You create a cube in the SSAS instance that contains a ragged hierarchy.
- You use a client application to connect to the SSAS instance, and then you set the MDX Unique Name Style property to "2" in the connection string. This property uses the following name path algorithm: [dim].[n1].[n2]
- You write an MDX query to reference the ragged hierarchy members by using the Name Style 2 method.
In this scenario, the query does not return items for the referenced member.
Cumulative update informationThe fix for this issue was first released in Cumulative Update 6. For more information about how to obtain this cumulative update package for SQL Server 2008 R2, click the following article number to view the article in the Microsoft Knowledge Base:
Article ID: 2496707 - Last Review: Feb 21, 2011 - Revision: 1