Let's assume we don't use SCD2 on the fact table.

ID SalesPersonID ProductID SaleMonth Quantity Revenue

110110012012-0110100

210110022012-01464

310110032012-01336

Then we bring the table to some Reporting tool like BO, OBIEE, Cognos.

We define the aggregates:

SUM(Revenue)...

I dont see any easy way to maintain AVG measures in this model. We need two layers of aggregations.

SUM to construct the full amount and only then AVG. This is...