dbTalk Databases Forums  

the Calculation member can't use another one defined before

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss the Calculation member can't use another one defined before in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Rick
 
Posts: n/a

Default 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



Reply With Quote
  #2  
Old   
Rick
 
Posts: n/a

Default Re: the Calculation member can't use another one defined after - 10-13-2003 , 08:21 PM






Excuse me, 'before' should be 'after'.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.