Hi,

I've got the a parent-child "Portfolio tree" Dimension with a member
property "RATIO" and a facts table with the measure "DTD".

Part of the protfolio tree looks like:

BONDS (???)

The BONDS level has n-children. What I want to to is to calculate the
sum of weighted (with RATIO) DTD children on the BONDS-level.

Calculated member on the BONDS level in general:

"DTD_BONDS" = (DTD of children 1 * RATIO of children 1) +
(DTD of children 2 * RATIO of children 2) + ... + (DTD of children n *
RATIO of children n)


Hope somebody has an idea to implement this tricky formula.

Thanks a lot!!!

regards

Bruce

Something along the lines of

sum([portfolio tree].currentmember.children,DTD * [portfolio tree].currentmember.properties("ratio")

HTH
Bria
www.geocities.com/brianaltmann/olap.html