I've set a measure to AggregateFunction = None and when I drill down
in the browser, the value is always NULL. I'm using SQL 2005
Enterprise. Also will None work on Standard Edition since its not
semi-additive ?

I've seen the question posted before, but I've never found an answer.

Thanks !

I would expect the values to be NULL except on the leaf level. Are you
seeing NULL values on the leaf level too?

"andy" wrote:

Yep,

I'm seeing nulls on the leaf values too.





yongli wrote:

This thread on the Analysis Services MSDN Forum may help (assuming that
you're running SP1):

http://forums.microsoft.com/MSDN/Sho...16033&SiteID=1
....
The "None" aggregations seems to return a value if there's only a single
fact record at that leaf of the measure group (SP1). I seem to recall back in
the days of RTM that, if there were multiple fact records at a leaf, their
"Sum" was returned, rather than null. However, this no longer worked when a
fact dimension was configured.

Hopefully, someone from MS can corroborate this behavior - maybe it's by
design?
....
"andy" wrote: