Are there any tools for running MDX?

I am wondering if there are any tools for running MDX, just like Query Analyer for running SQL script.
Thanks for any comments.
FisheyThere is a Sample MDX application that is installed with AS2000. You can run MDX queries in this. I believe you need to run it either locally on the AS2000 server, or set up all of the DSNs on the client machine.

Hope this helps|||Thank you very much, MCrowley. That's probably what i need for now.

Could you tell me how to create a cube with Multidimensional Expressions (MDX) language? The MDX Sample Application is only for query data from cube, i think.

Thanks again.

Fishey|||Analysis services have object interface. See BOL topic "DSO".|||Thank you very much, ispaleny. I know how to use DSO to create a cube with VB, but now i want to use MDX syntax to create a cube, is there any workaround about it?

Thanks again.|||what about to use CREATE CUBE and INSERT INTO?

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/olapdmpr/pt_prddldml_3n1w.asp

jiri
:)|||Thank you ver much, playernovis.

Actually i have thought about CREATE CUBE, but CREATE CUBE is for creating a local cube ( stored with the extension .cub on a local computer). Can I use this syntax for creating a server-side cube?

Any comments?

Fishey