Derek-2008
SSC Enthusiast
Points: 176
More actions
March 2, 2010 at 2:54 pm
#216202
I started using DistinctCount in many measures and I see in SSAS 2000 to keep DistinctCount from counting NULL as a distinct value you had to create a dimension y/n if the measure is null. Is there any better way in 2005?
denglishbi
SSCrazy Eights
Points: 8831
March 5, 2010 at 8:08 pm
#1129535
Check out this thread in the Microsoft Forums DISTINCT COUNT MEASURE sql 2005 and also take a look at the article in the link - Handling Data Integrity Issues in SSAS 2005.
----------------------------------------------------------------------------------------Dan English - http://denglishbi.wordpress.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply