Hi, everybody!

I am looking for help with MDX (or an advice on whether it would be better
to implement it in SQL before the cube is built) with the following:

I have a cube with

2 measures:
FunctionElapsedTime
FunctionExecCount

3 dimensions:
Time
FunctionType->Function->Subfunction
UserLocation->...->userid

Calc Member:
ExecutionAvg = FunctionElapsedTime/FunctionExecCount


I need to calculate the same average for just bottom 95% of
FunctionElapsedTime for all dimensions and levels as well as to display the
rest of the members ordered by the measure.
Another similar task is to calculate the same avg for FunctionElapsedTime >
4 sec - I just want to make sure that it is really similar as far as MDX is
concerned.

Thanks in advance,
Koni.