SQL Server Performance

Distinct Count with text Data Type

Discussion in 'Analysis Services/Data Warehousing' started by loui, Mar 1, 2007.

  1. loui New Member

    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
  2. dineshasanka Moderator

    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/
  3. loui New Member

    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?

Share This Page