Is there any DOS utility can run MDX query ( like sqlcmd and osql for TSQL.)?
We need schedule a MDX query for creating a local cube file.
Appreciate any help on this.
The ASCMD utility, provided as one of the SSAS samples, can be used for this kind of thing. Here's a link on how to use it:
http://msdn2.microsoft.com/en-us/library/ms365187.aspx
Samples can be downloaded at:
http://msdn2.microsoft.com/en-us/library/ms365187.aspx
Please note, you will need to compile the utility per the instructions provided.
Good luck,
Bryan
Thank you so much for the answer, I am going to try that.
Appreciated your help.
