You can create calculated measures to do the averages. Eg. (from Foodmart 2000)

Sales Average = [Measures].[Store Sales]/[Measures].[Sales Count]

Otherwise, some OLAP browser come equipped with aggregate functions to choose from.

>> It is worth remembering that if a table is referenced by a foreign key constraint you cannot use the TRUNCATE TABLE statement on that table.

If you really want to...