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,
VaradMDX 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.