Hi, I am using 2X Client for connection one of my SSAS Server. After connecting the same, i use wizard to execute some MDX queries and paste the output into excel files. I want to automate this process, is there any command (Appserver or TSClient commands) to execute MDX queries. I am able to open the 2X client window using APPServerClient.exe s!='XX.XXX.XXX.XXX' a!='XXXX' t!='port' d!='XXXX' u!='XXXX'q!='XX' m!='2' sqlcmd -S XX-XX -i C:\CPLS.sql -o C:\EmpAdds.txt command and not been able to save the data into txt file. It opens the wizard only. I want to automate this process, any help (SSIS Package or CMD commands) . Your help is highly appreciated. Pratt..
