AggregationFunction = None

Hi,

this is what I find about the AggregationFunction "none":

No aggregation is performed, and all values for leaf and nonleaf members in a dimension are supplied directly from the fact table for the measure group that contains the measure. If no value can be read from the fact table for a member, the value for that member is set to null.

I understand that there will no calculated aggregation (this is quite obvious). But how can I retrieve a aggregation from a fact table? How should I design a fact table including aggregates and how do I work with that?

Thanks,

Look at:

http://www.sqlserveranalysisservices.com/default.htm

In the white paper titled: "Load Aggregate Data". I think this talks about the circumstances you are interested in.

_-_-_ Dave

|||

Dave,

thanks, I think this was the right link for me...