Hi,
I am using MS Analysis Services(AS)for cube building. I
need to create distinct count measure on 'varchar'
datatype based column. But MS AS cube does not allow
distinct count function to be performed on varchar column.

What is the solution..?

thanks,
durai

AS 2000 will not allow VARCHAR type for any Measure

One Soln is to have a INT column in the relational adatabase and update it with corr. values (Particular value of VARCHAR Column should corr. to a specific Numberin INT Column. ). and use this INT Column for defining the Distinct Count measure

- Sank
----- Durai wrote: ----

Hi
I am using MS Analysis Services(AS)for cube building. I
need to create distinct count measure on 'varchar'
datatype based column. But MS AS cube does not allow
distinct count function to be performed on varchar column

What is the solution..

thanks
dura

Hi,
You should rather consider using "Calculated Member" instead, there you have
the possibility of using a distinct count with Varchar.

Regards,
Khoosun.

"Durai" wrote: