Microsoft KB Archive/299383

= FIX: Incorrect Results Returned from MDX Query When Default Member Is Defined by User =

Article ID: 299383

Article Last Modified on 11/21/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-



This article was previously published under Q299383



BUG #: 12269 (Plato7.x)



SYMPTOMS
If a user-defined default member is added to a dimension, any query against the cube that contains the dimension may result in incorrect results.



RESOLUTION
To resolve this problem, obtain the latest service pack for the Microsoft SQL Server 2000 (the Analysis Services Components - Sql2kasp1.exe). For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 INF: How to Obtain the Latest SQL Server 2000 Service Pack



WORKAROUND
To work around the problem, add the user-defined default member to the WHERE clause of the MDX statement as a slicer.



STATUS
Microsoft has confirmed that this is a problem in SQL Server 2000 Analysis Services version 8.0. This problem was first corrected in the Analysis Services Components of Microsoft SQL Server 2000 Service Pack 1.



Steps to Reproduce Behavior
  Use the Analysis Manager Dimension Editor to define the High School Degree member of the Education Level dimension as the default member in the Foodmart 2000 Sales cube. Enter the level as follows: [Education Level].[Education Level].&[High School Degree]  Reprocess the Sales cube.  Use the MDX Sample application to run the following query: SELECT NON EMPTY { [Measures].[Sales Count] } ON COLUMNS , NON EMPTY { ORDER( {DESCENDANTS([Customers].[State Province].&[WA].&[Seattle],[Customers].[Name] ) }, ( [Measures].[Sales Count] ), BDESC ) } ON ROWS FROM [Sales] The results are out of order and the values are incorrect.   To see the correct results, run the following query: SELECT NON EMPTY { [Measures].[Sales Count] } ON COLUMNS , NON EMPTY { ORDER( { DESCENDANTS( [Customers].[State Province].&[WA].&[Seattle], [Customers].[Name] ) }, ( [Measures].[Sales Count] ), BDESC ) } ON ROWS FROM [Sales] WHERE ([Education Level].[Education Level].&[High School Degree] ) </ol>

Additional query words: OLAP

Keywords: kbbug kbfix kbssas800sp1fix KB299383

-

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

© Microsoft Corporation. All rights reserved.