Hi,

Have you seen the following topic ic BOL of Analysis server:

BOL topic "Specifications and Limits":

Source Column Data Types
The data type of the source column for a measure must be numeric
except when the Count or Distinct Count aggregate function is used.

The data type of the source column for a dimension level must be
string or numeric (except currency).

OLE DB Data Types
Columns of the following OLE DB data types may be used as measures or
dimension levels. Columns types that are marked with an asterisk are
supported data types for data mining model columns.

DBTYPE_BOOL*

DBTYPE_I1

DBTYPE_I2

DBTYPE_I4*

DBTYPE_UI1

DBTYPE_UI2

DBTYPE_UI4

DBTYPE_I8

DBTYPE_UI8

DBTYPE_R4

DBTYPE_R8* (Note: Data mining model column inputs of this type will
be cast to a 4 byte floating point number)

DBTYPE_DECIMAL

DBTYPE_NUMERIC

DBTYPE_VARNUMERIC

DBTYPE_CY

DBTYPE_DATE*

DBTYPE_DBDATE

DBTYPE_DBTIME

DBTYPE_DBTIMESTAMP

Columns of the following OLE DB data types may be used as measures
only if the Count or Distinct Count aggregate function is used. These
data types may be used as dimension levels.

DBTYPE_BYTES

DBTYPE_HCHAPTER*

DBTYPE_STR

DBTYPE_WSTR*


HTH,
Bas