Article ID: 293195 - View products that this article applies to.
This article was previously published under Q293195
This article has been archived. It is offered "as is" and will no longer be updated.
BUG #: 11928 (plato7x) BUG #: 11998 (plato7x)
When you run a Multidimensional Expressions (MDX) query and you use the Member clause to define virtual levels, and you use the colon operator to define a range for the virtual levels, you may receive incorrect results from the MDX query.
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:
(https://support.microsoft.com/kb/290211/EN-US/ )INF: How to Obtain the Latest SQL Server 2000 Service Pack
HotfixNOTE: The following hotfix was created prior to Microsoft SQL Server 2000 Service Pack 1.
The English version of this fix should have the following file attributes or later:
NOTE: Due to file dependencies, the most recent hotfix or feature that contains the preceding files may also contain additional files.
Date Time Version Size File name ------------------------------------------------- 3/8/2001 8:37p 220.127.116.11 209,472 Msmdcb80.dll 3/8/2001 8:37p 18.104.22.168 1,360,448 Msmdgd80.dll 3/8/2001 8:37p 22.214.171.124 1,733,180 Msmdsrv.exe 3/832001 8:37p 126.96.36.199 1,983,056 Msolap80.dll 3/8/2001 8:37p 188.8.131.52 213,067 Msolap80.rll
To work around this issue, increase the size of the Large Level Threshold property on the connection string of the client application. For example:
The value may vary depending on the size of the query, so you may want to start at a value of 10000.
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.
Here is sample syntax for a MDX query that generates incorrect results.
Article ID: 293195 - Last Review: October 23, 2013 - Revision: 1.1