Microsoft KB Archive/926045

= BUG: Error message when you try to use a data mining model in a SQL Server 2005 Analysis Services project: &quot;Errors in the metadata manager The data type of the 'Customer_Integer ~MC' measure must be the same as its source data type&quot; =

Article ID: 926045

Article Last Modified on 1/12/2007

-

APPLIES TO


 * Microsoft SQL Server 2005 Analysis Services

-



Bug #: 485965 (SQLBUDT)



SYMPTOMS
When you try to use a data mining model in a Microsoft SQL Server 2005 Analysis Services project, you may receive an error message that resembles the following:

Errors in the metadata manager. The data type of the 'Customer_Integer ~MC' measure must be the same as its source data type. This is because the aggregate function is not set to count or distinct count.

This problem occurs if the following conditions are true:
 * The data mining model uses an Analysis Services cube that has a distinct count measure.

Note A distinct count measure is a measure that has an Aggregate Function property that is set to the Distinct Count value.
 * The distinct count measure uses a nonnumeric data type in the underlying table.



WORKAROUND
To work around this problem, define a calculated measure that is based on the distinct count measure. Then, use the calculated measure instead of the distinct count measure to create the data mining model.



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



MORE INFORMATION
For more information about calculated members, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn2.microsoft.com/en-us/library/ms166568.aspx

Keywords: kbexpertiseadvanced kbsql2005as kbnofix kbbug kbtshoot KB926045

-

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

© Microsoft Corporation. All rights reserved.