AggregateFunction Does "None" Work?

Does the AggregateFunction of "None" actually work?

I have a fact table with a single related dimension. The dimension is for a set of products, with a four-level user hierarchy. The fact table has a measure that only makes sense at the lowest level of the product hierarchy. Thus, when designing the measure group, I created a measure from the fact table and set the AggregateFunction on the measure to "None". I expected to be able to browse down the product hierarchy and see the value of the measure at the lowest level of the hierarchy. Unfortunately, I don't see any values (everything appears to be Null).

To ensure the values were getting read, I created a second measure in the measure group using the AggregateFunction of "Sum". When I browse the product hierarchy, I indeed see the sum of the measure and I see the individual measure values if I drill down to the lowest level of the hiearchy.

Thus, it would appear to me that the AggregateFunction of "None" is not working properly. Or perhaps I am interpreting its use incorrectly (or doing something else wrong). But with a single fact table that has a single dimension, its not very complicated!

TIA for any help...

Dave Fackler

Hi Dave,

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?

|||

Hi Dave/All

Did you get an answer to this issue? I have recently tried using AggregateFunction = None, and I to expected the function to behave as you described. I have a dimension which has a one-to-one mapping to the fact table, yet I am still unable to view the measure data.

Would anyone be able to advise how the Non function should be used?

Regards, Matt

|||

Hey All,

I'm having the same issue..Aggregate Function "None" doesnt work ? Any one got it to work...

I have a boolean one-one measure and want to display True/False

Thanks