the Calculation member can't use another one defined before -
10-13-2003
, 08:16 PM
Hi, this seems very strange:
Suppose I create a calculation member [Measure].[Unit Sale] first.
Second, I create another calculation member [Measure].[Amount]. The two
calculation member now has no relation to each other. Last, I want to modify
the MDX of the [Measure].[Unit Sale] to be [Measure].[Amount]+1.0.
However, the syntax error is reported. I do all this in the MDX editor
in analysis manager.
What does this mean? Why MS handle it like that? How can I get around
it?
Best Regards
Rick |