Microsoft KB Archive/938585

= FIX: Additional data columns for ascendant members are returned unexpectedly when you run an MDX statement against an instance of SQL Server 2005 Analysis Services that has SQL Server 2005 Service Pack 2 installed =

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.



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 &quot;Applies to&quot; section.

Additional query words: OLAP FLATTENED ROWSET MDX

Keywords: kbfix kbqfe kbpubtypekc kbexpertiseadvanced kbhotfixserver kbsql2005as kbsql2005bi KB938585

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.