Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2003
    Posts
    18

    Question Unanswered: 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.

    Fishey

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11

    Re: Are there any tools for running MDX?

    There 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

  3. #3
    Join Date
    Jan 2003
    Posts
    18

    Re: Are there any tools for running MDX?

    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

  4. #4
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249
    Analysis services have object interface. See BOL topic "DSO".

  5. #5
    Join Date
    Jan 2003
    Posts
    18
    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.

  6. #6
    Join Date
    Nov 2002
    Location
    San Francisco
    Posts
    251
    what about to use CREATE CUBE and INSERT INTO?

    http://msdn.microsoft.com/library/de...dldml_3n1w.asp



    jiri

  7. #7
    Join Date
    Jan 2003
    Posts
    18
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •