Home > Archive > MS SQL Data Warehousing > December 2005 > Re: Measure with "Distinct Count" Aggregate Function and Null valu









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: Measure with "Distinct Count" Aggregate Function and Null valu
Erik Veerman

2005-12-16, 1:23 pm

Even if you didn't have the NULL challenge with Distinct Count, creating a
separate cube for the Distinct Count is a best practice. There are
aggregation and query performance benefits.

The dimensional granularity to the distinct count cube (with the NOT NULL
filter) would be identical to the other cube, so any queries against the
virtual cube would not require any special calculations.

Erik
----
Erik Veerman
erik (at) solidqualitylearning
.com

"Paulo Andre Ortega Ribeiro" wrote:

>
> I tried this solution and It works. But I don4t want to create a new
> cube. That will be my last option. Is not possible to ignore the null
> vules with "distinct count" as the aggregate function? Is not there a
> propriety that I can configure?
>
> Thanks,
>
> Paulo
>
>
> *** Sent via Developersdex http://www.droptable.com ***
>
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com