I need to use field type of Char as the source for
distinct counts within a Cube.

The SQL BOL states that if using distinct counts, you
could use OLEDB datatypes of:
DBTYPE_BYTES,DBTYPE_HCHAPTER,DBTYPE_STR,DBTYPE_WST RDBTYPE_S
TR as measures.
is IBM DB2 Datatype of Char, or Varchar not part of the
above datatypes?
Seems that Distinct Counts can only be used with datatypes
of Int.

I need to make it work with a Char field type which is the
datatype of one of the foreign keys.

Any ideas

Thanks
Dharmesh Kalyan

Hi Dharmesh,

You are correct. For DISTINCT COUNT measure, the datatype
should be INT.

May be you can add a new column which holds a numeric
value for each CHAR value in the exisitng column and have
the DISTINCT COUNT aggregation type on the newly added
numeric column.

Cheers,
Sanka