Microsoft KB Archive/297823

= FIX: Incorrect Data Displays in PivotTable When it is Filtered and AutoCalc is Set to Max or Min =

Article ID: 297823

Article Last Modified on 11/21/2006

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-



This article was previously published under Q297823



BUG #: 11468 (Plato7.x)



SYMPTOMS
Data that displays through the pivot table is inconsistent, and the display changes depending on the selection of data. This behavior occurs when the AutoCalc function is set to MAX or MIN, and a filter is set on the filter axis.

You also see inconsistent data with any Analysis Services client that uses the Aggregate function in a Multidimensional Expression (MDX) query.



CAUSE
The MDX Aggregate function returns incorrect data. The pivot table uses the MDX Aggregate function when it attempts to display the minimum or maximum value for AutoCalc.



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



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.

Additional query words: PIVOTTABLE AUTOCALC FILTER OLAP OWC

Keywords: kbbug kbfix kbssas800sp1fix KB297823

-

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

© Microsoft Corporation. All rights reserved.