FIX: Incorrect Results Returned from MDX Query When Default Member Is Defined by User (299383)

MORE INFORMATION

Steps to Reproduce Behavior

1. 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]
   					

2. Reprocess the Sales cube.
3. 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.
4. 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] )