dbTalk Databases Forums  

Distinct count on Non-numeric felds

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.olap Distinct count on Non-numeric felds

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Distinct count on Non-numeric felds in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jim Fox
 
Posts: n/a

Default Distinct count on Non-numeric felds - 02-08-2004 , 01:04 PM





Apparently Distinct Count cannot be used on non-numeric measure fields?
Is this true, or is there a way Distinct Count text char or varchar fields?
Any idea why this is so?
Thanks,
Jim



Reply With Quote
  #2  
Old   
Sanka
 
Posts: n/a

Default Distinct count on Non-numeric felds - 02-08-2004 , 09:40 PM





Its TRUE that Distinct Count cannot be used with non-
numeric measure fields in Analysis Services 2000.

Sanka

Quote:
-----Original Message-----
Apparently Distinct Count cannot be used on non-numeric
measure fields?
Is this true, or is there a way Distinct Count text char
or varchar fields?
Any idea why this is so?
Thanks,
Jim


.

Reply With Quote
Reply

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top