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 Rhinorhino 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
Joined
Jan 29, 2004
Messages
3
Location
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
Problem now solved
 
Upvote 0 Downvote
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 Question
Distinct counts in SSRS Report Builder 3.0 with cube
Replies
1
Views
787
blom0344
blom0344
nodoubtom
  • Locked
  • Question Question
SSAS Distinct Count Sum
Replies
0
Views
232
nodoubtom
nodoubtom
eo
  • Locked
  • Question Question
MDX & distinct count & date ranges
Replies
3
Views
361
eo
eo
Recce
  • Locked
  • Question Question
Drill through return random sets of row counts ?
Replies
2
Views
349
Recce
Recce
eo
  • Locked
  • Question Question
Nulls, distinct counts and SSAS2005 - limit slicing of a measure
Replies
0
Views
122
eo
eo

Part and Inventory Search

Sponsor

Back
Top