Microsoft KB Archive/939567

= You obtain an incorrect result or receive a &quot;Formula error - cannot find dimension member&quot; error message when you run a MDX query in SQL Server 2000 Analysis Services =

Article ID: 939567

Article Last Modified on 9/25/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Analysis Services

-



SYMPTOMS
Consider the following scenario:
 * You have a Multidimensional Expressions (MDX) query that uses a key column value.
 * The data type of the key column is date.
 * The following settings on the client computer where you run the MDX query differ from the analogous settings on the Microsoft SQL Server 2000 Analysis Services server that was used to process the data.
 * The locale setting
 * The comparison flag setting

In this scenario, you may experience one of the following symptoms when you run the MDX query:  You obtain an incorrect result. You receive the following error message:

Formula error - cannot find dimension member (&quot; &quot;) - in a name-binding function

For example, you receive the following error message:

Formula error - cannot find dimension member (&quot;[Time].[Standard].[Quarter].&[4/1/2002]&quot;) - in a name-binding function





CAUSE
This problem occurs because the client computer interprets the date value differently than the Analysis Services server that was used to process the data.



WORKAROUND
To work around this problem, change the data type of the key column to string.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
When the client components of SQL Server 2000 Analysis Services receive data from the cube that is processed by the Analysis Services server, the client components use the data and then cache the data. If the locale setting and the comparison flag setting on the client computer differ from the analogous settings on the Analysis Services server, conflicts occur.

For example, the client computer has a locale of French or of Spanish. The Analysis Services server has a locale of the United States. The MDX query uses a date value of 4/12/2007. In this example, the client computer resolves the date value as December 4, 2007. However, the Analysis Services server resolves the date value as April 12, 2007. If you run the MDX query to retrieve data from the cube that is processed by the Analysis Services server, you obtain an incorrect result.

Keywords: kbexpertiseadvanced kbhowto kbinfo KB939567

-

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

© Microsoft Corporation. All rights reserved.