That's a common scenario and was a pain in the neck to get results using Analysis Services 2000.
In SSAS 2005 we have.... SEMI ADDITIVE MEASURES: by using this measures we use SUM for all the dimensions but not for the time dimensions (watch out you
Read More