FIX: The calculated member that uses the ValidMeasure function may return an incorrect value in a virtual cube (317562)


The information in this article applies to:

  • Microsoft SQL Server 2000 Analysis Services
This article was previously published under Q317562
BUG#: 12766 (Plato7x)

SYMPTOMS

When a custom rule is defined on a dimension of a Microsoft SQL Server 2000 Analysis Services virtual cube, and if a calculated member of the virtual cube uses the ValidMeasure function, the calculated member may return incorrect data.

CAUSE

This behavior occurs when the user account that is used to connect to the Analysis Services virtual cube is not a member of the OLAP administrators group.

RESOLUTION

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

290211 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. The English version of this hotfix has the file attributes (or later) that are listed in the following table. The dates and times for these files are listed in coordinated universal time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.
   Date      Time   Version            Size     File name
------------------------------------------------------------
19-Mar-2002  01:57      8.0.0.601   4,043,328  Msmddo80.dll
19-Mar-2002  01:56      8.0.601.0   1,008,192  Msmdgd80.dll
19-Mar-2002  12:53      8.0.601.0   1,774,148  Msmdsrv.exe
19-Mar-2002  01:57      8.0.601.0   2,024,016  Msolap80.dll
18-Apr-2001  12:23  2000.80.382.0     815,676  Sqldata.dll
19-Mar-2002  01:56  2000.80.534.0     590,396  Sqlsort.dll


Note Because of file dependencies, the most recent fix that contains the previous files may also contain additional files.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section of this article.

REFERENCES

For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:

295706 FIX: Virtual cube returns empty cells if custom rule is applied

295683 FIX: Virtual cube returns #ERR if you use Dimension Security and Visual Total together

Modification Type:MajorLast Reviewed:2/23/2004
Keywords:kbSQLServ2000preSP3fix kbbug kbfix KB317562 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.