I have a parent-child dimension in in an OLAP database. With some members I only want to aggregate a certain percentage of the measures in the fact table.

I know I need to create a column in the underlying dimension table to hold an MDX expression, but what is the syntax of the expression?

I have tried: H_Cons.&[27] * 0.33 and Measures.[value] *0.33 etc etc.

All I get is #ERR when i browse the cube data post processing.

I have found an example in the Foodmart database but it doesn't bear the slightest resemblence to what I am trying to do.

Anyone got any ideas??? Maybe an example???

Cheers
Mike