Hi,

Is there something analagous to T-SQLs stored procedures which I can
use to run MDX code on cubes?

If not, what are the standard techniques for dealing with large bodies
of MDX code?

Thanks,

David

Nope, unfortunately.

public @ the domain below
www.tomchester.net

"DaveS" <davesimard (AT) hotmail (DOT) com> wrote

Dave, what do you mean by "run MDX code on cubes" ?

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

David,

This is coming in Microsoft's next version of Analysis Services
(codenamed Yukon). It's part of the CLR integration and you can write
a stored proc in any .NET language. The debugger can even step through
the stored proc. I've seen this in action and it's very cool. But
until then ....

Gabhan Berry
AI Prediction and Forecasting in Excel
http://www.pececillo.com

davesimard (AT) hotmail (DOT) com (DaveS) wrote in message news:<f8e708df.0312091449.6c36531d (AT) posting (DOT) google.com>...

Gabhan - I think that what Dave was looking for will be accomplished in
Yukon by MDX Scripts rather then by stored procedures. However I am still
not certain what exactly Dave meant by "run MDX on cube", therefore I asked
him this question.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================
"Gabhan Berry" <gabhan_b (AT) yahoo (DOT) co.uk> wrote