Hi,

I´m a newbie in MDX.
I want to create a calculated member which shows the percetage allocation of
a measure. I have the following code:

CREATE MEMBER [myCube].[Measures].ZM1 AS
'(RD1.CurrentMember, [Measures].ZM1perc) / (RD1.CurrentMember.parent,
[Measures].ZM1perc)'

When I only have one dimension everthing is OK. But when I have more than
one dimension, starting at the second dimension the value of
"(RD1.CurrentMember.parent, [Measures].ZM1perc)" is wrong.
I want to have 2 different behavior:
1.
Dim1 Value
M1 30%
M2 60%
M3 10%
--------------------------- expand M1
Dim1 Dim2
M1 B1 10%
B2 15%
B3 5%
M2 B4 30%
... ... ...

2.
Dim1 Value
M1 30%
M2 60%
M3 10%
--------------------------- expand M1
Dim1 Dim2
M1 B1 23%
B2 60%
B3 12%
M2 B4 30%
... ... ...

Any ideas how I can do this?

Regards,
Thorsten Blawatt