I'm using sql2k5 and working with the calc scripts in the Calculation.
I done a second pass calculation using "calculation;" again but it
doesn't seem to recognize it. What am i doing wrong?

As I understand it, with the RTM version of AS2005 there will never be any
need to have more than one CALCULATE statement in your MDX Script. It works
as a kind of switch, meaning that aggregation can be thought of as taking
place after every statement in the script that appears after it - it does not
just perform an aggregation at the point that it appears in the script.

This is quite difficult to explain without an example - can you give some
more details on what you're trying to achieve?

Chris

--
Blog at:
http://spaces.msn.com/members/cwebbbi/


"ricocali (AT) hotmail (DOT) com" wrote: