Hi,



I have fact table with column buying customer id where I put customer
id when he has bought something or null when he has not (during
emploee visit).

I would like to have measure that tells me the number of buying
customers. So I created a measure on mentioned column with agregate
function distinct count. But distinc count counts null as one of values
so sometimes I get result which is acutal number of buying customers
plus one (null). Any hints on workaround?



Thanks in advance

Bartlomiej Bojko


--
Posted via http://dbforums.com

You won't be able to do this using the distinct count aggregate. Instead
you can use the approach outlined in the following whitepaper. It's a
different topic, but the technique described should be applicable.

http://msdn.microsoft.com/library/de.../distinct2.asp


--
Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.


"Montechristo" <anonymous (AT) discussions (DOT) microsoft.com> wrote

just seems to be no solution to show the customer count that had sales the
last two years (per salesengineer and even on day level going back two
years).

Thx alot ...!
it works! (though there are still some performance considerations ... really looking forward to OWC 2003 where calculated measures are processed server-side ;-) )

What ... ?

There is already the execution location property - we tried to use it in a
model with LOTS of calc measueres with not much luck. Does this mean
that this will be improved - or the calc measures will be added to the
aggregations in the cube ?


Montechristo <anonymous (AT) discussions (DOT) microsoft.com> wrote

server-side ;-) )