I need to SUM by region hierarchy on a given measure, but use the average function when dealing with time entrieshttp://blog.avanadeadvisor.com/blogs/braulio_malaga/archive/2007/05/15/1406.aspxThat'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 youen-USCommunityServer 2.0 (Build: 60217.2664)