Summing Multiple Measures in MeasureGroup

i'm trying sum multiple measures in measure group using calculated member:

with member [measures].[mycustomsum] sum(measuregroupmeasures("my measures"))

however, i've noticed yields considerably terrible performance opposed manually adding measures like:

with member [measures].[mycustomsum] ([measures].[my measure a] + [measures].[my measure b] + [measures].[my measure c])

measuregroupmeasures isn't optimized block computation. expect slower performance on large queries: https://msdn.microsoft.com/en-us/library/bb934106(sql.100).aspx

---

http://artisconsulting.com/blogs/greggalloway

SQL Server  >  SQL Server Analysis Services