Hi There!
I have a little problem.
If it is possible to define different kind of calculations
i the same dimension. What I mean is for
example: I have parent-child hierarchy in some dimension.
I defined Calculationin percent but
what is more important for me I'd like to have
on last level (one leaf) not in procent but avg aggregations.

Is it possible?

Regards,
Saidor

Get a copy of TREES & HIERARCHIES IN SQL and look at the Nested Sets
model.