Microsoft KB Archive/321719

= FIX: Zeros Returned Incorrectly from OLAP Data Source with Calculated Measures =

Article ID: 321719

Article Last Modified on 2/19/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services
 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q321719



SYMPTOMS
If you build a PivotTable in Excel 2000 by using a SQL Server Analysis Services cube as the data source, and calculated measures are added to the data area of the PivotTable, the values that display in the PivotTable are zero (0), even though the Analysis Manager Cube Browser and Microsoft Excel 2002 display data values.

This problem only occurs if the definition for the calculated measure that is being displayed references another calculated measure that uses the Multidimensional Expressions (MDX) DistinctCount function.



CAUSE
A problem with the DistinctCount function in SQL Server 2000 Analysis Services.



RESOLUTION
To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2000. 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

NOTE: The following hotfix was created before the release of Microsoft SQL Server 2000 Service Pack 3.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

This problem was first corrected in Microsoft SQL Server 2000 Service Pack 3.

Additional query words: XL2000 DistinctCount PivotTable OLAP Calculated Member

Keywords: kbfix kbsqlserv2000sp3fix kbprb kbsqlserv2000presp3fix KB321719

-

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

© Microsoft Corporation. All rights reserved.