We have a custom rollup along a dimension:
---------------------------------------------
Custom rollup of the measure [X], along the dimension [Commission]
(
(Commission A, X) * (Commission A, Y)
+ (Commission B, X) * (Commission B, Y)
+ ...
)
/
(
(Commission A, Y)
+ (Commission B, Y)
+ ...
)

[X] - a measure
[Y] - another measure
[Commission] - dimension (A, B, ..., members underneath level ALL of
[Commission])
---------------------------------------------
The above is manageable if the number of members in the [Commission]
dimension is limited.

What there are lots of members? Is there a some kind of summing-up
function?

What would be an alternative way to do this kind of rollup?

Tao Zuo
tzuoo (AT) allstate (DOT) com