I can define a new measure "[Measures].[Weighted Units]" and set its Measure Expression to:
[Measures].[Units] * [Measures].[Allocation]
this gives me the correct results in Cube browser. Note that [Measures].[Allocation] represents a percentage, by which we scale down the Units based on selection in other dimensions.
When i try to do the same through MDX script:
Leaves()) = [Measures].[Units] * [Measures].[Allocation];CALCULATE;
({[Measures].[Weighted Units]},
i'm not getting the right results: the multiplication does not seem to get applied and "Weighted Units" shows the same values as "Units".
I would need to use MDX script because of the limitations of Measure Expressions (ie. i will need to define other measures based on "[Measures].[Weighted Units]").
Any idea why the MDX script does not work