Results 1 to 2 of 2

Thread: MDX Query

  1. #1
    Join Date
    Jun 2002
    Location
    USA
    Posts
    21

    Unanswered: MDX Query

    Hello,

    1.

    I would like to execute my mdx query from dos prompt? is there any way? I was fighting with MDXsampl.exe but could not find solution.

    2. Is it possible to schedule MDX query and save the output to an output file like using "isql/osql"

    Appreciate any help on this.

    Thanks,
    Varad

  2. #2
    Join Date
    Aug 2003
    Posts
    51
    MDX Queries can be executed through OLEDB/MD Connections. It would be possible to create an application (10 - 20 lines of code), possibly even a vbs to execute an MDX query. You will end-up with a cellset that you would be responsible for writing out to the file if that's what you are looking for.

    I'll check to see if I have any code samples.

Posting Permissions

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