Knowledge Base

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

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 "Applies to" 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

Microsoft KB Archive/926045

Contents