Article ID: 938585
Article Last Modified on 9/11/2007
APPLIES TO
- Microsoft SQL Server 2005 Service Pack 2, when used with:
- Microsoft SQL Server 2005 Analysis Services
SYMPTOMS
Consider the following scenario. You have a Multidimensional Expressions (MDX) statement that uses the DIMENSION PROPERTIES keyword to retrieve member properties. You run the MDX statement against an instance of Microsoft SQL Server 2005 Analysis Services that has Microsoft SQL Server 2005 Service Pack 2 (SP2) installed. The MDX statement returns the result in a flattened rowset. In this scenario, additional data columns for ascendant members are returned unexpectedly.
RESOLUTION
Cumulative update information
To resolve this problem, obtain the cumulative update package (build 3175) for SQL Server 2005 SP2. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
936305 Cumulative update package 2 for SQL Server 2005 Service Pack 2 is available
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Additional query words: OLAP FLATTENED ROWSET MDX
Keywords: kbfix kbqfe kbpubtypekc kbexpertiseadvanced kbhotfixserver kbsql2005as kbsql2005bi KB938585