Distinct Count with text Data Type | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Distinct Count with text Data Type

Hello, Can anyone help me?
How can i create measures (with text data type) in my cubes with DistinctCount aggregate function? Cause there is only Sum, min, max, and count in aggregate function properties. Thanks before for all your help. Best regards, Loui
well, in cubes, you have aggrigate functions. what do you want to with test fileds. AFAIK, you can have dimensions with text fileds. —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at
http://dineshasanka.spaces.live.com/

Thanks for your reply dine [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />I need to count our Aktive customer.<br /><br />So i must create Customer_ID as a measure with distinctcount on aggregate function.<br />But when i wan to change aggregate function properties, there is only Sum, min, max, and count. Looks like its all because my Customer_ID field is text.<br /><br />Do you know how to change measures properties (aggregate function) into distinctcount?<br />or <br />Can u tell me how to create a measurement to count my Aktiv Customer?
]]>