Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Distinct Count

Status
Not open for further replies.
Matt2004

Matt2004

Technical User
Jan 29, 2004
3
GB
Can anyone tell me if the Distinct Count aggregation works only with numeric data types?

If this is the case, can anyone suggest how I can substitute an alpha-numeric value i.e. The Customer ID in a fact table, for a distinct numeric value.

Thanks
 
Sort by date Sort by votes
I meet the same problem,can you tell me how you solved?
thanks!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

JanetStackpole
  • Locked
  • Question
Distinct counts in SSRS Report Builder 3.0 with cube
Replies
1
Views
166
blom0344
blom0344
nodoubtom
  • Locked
  • Question
SSAS Distinct Count Sum
Replies
0
Views
65
nodoubtom
nodoubtom
eo
  • Locked
  • Question
MDX & distinct count & date ranges
Replies
3
Views
95
eo
eo
Recce
  • Locked
  • Question
Drill through return random sets of row counts ? 1
Replies
2
Views
95
Recce
Recce
eo
  • Locked
  • Question
Nulls, distinct counts and SSAS2005 - limit slicing of a measure
Replies
0
Views
33
eo
eo

Part and Inventory Search

Sponsor

Back
Top