When trying to generate rollup measures for further statitical analysis from an OLAP cube, completing in MDX proved much more efficient then querying and running PROC MEANS steps.

Included is an example of how to utilize the DRILLUPMEMBER() function in MDX code:

http://www.databasejournal.com/features/mssql/article.php/10894_3572621_2