I have a fact table that looks like the following

ProductID Sales PartID PartCost
A 100 a1 10
A 100 a2 15
B 50 b1 7
B 50 b2 6
B 50 b3 5
Total Sales for A and B are 100 and 50 respectively
Costs for A and B are 25 and 18 respectively

Because of the repetition of sales due to attaching the partid information,
I need the parent of the leaf level for sales to average and change to sum
for each parent above it.

A virtual cube will not work for what I need because of the large number of
dimensions.

Can you change the aggregation method used in the cubes while processing is
taking place????

I did play with calculated cells and learned all about recursion(a fine
concept, especially when you cant get rid of it until you learn about pass
order)
I have a feeling the answer is in calculated cells and which pass order to
use.

Any help would be appreciated.

bob