TSClient commands to execute MDX Queries

Discussion in 'Parallels Client for Windows' started by prateek.joshi84, Jun 18, 2015.

  1. prateek.joshi84

    prateek.joshi84

    Messages:
    2
    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..
     

Share This Page