How to run .XMLA on Analysis Services script via SQL Server Database Engine?

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Miguel Costa Mr or Mrs. 500 Points: 576 More actions · Answer 1

You can run your xmla query on Management Studio in File->New-> Analysis Services XMLA query.

If you want to automate it you can run that query in an Analysis Services Execute DDL Task in SSIS and then you can schedule it on a job.

tlaughlin SSC Journeyman Points: 83 More actions · Answer 2

I just did this exact thing. The answer is not sqlcmd, but ascmd. From command line, my command looks like this:

ascmd -i "E:\path\CubeDeploy.xmla" -S Server\Instance

You can do a lot of things programmatically. In my case, I am automating building of the cube, building of the XMLA script, and deployment.

Here are some links I used to help me with this:

jjradha SSChasing Mays Points: 617 More actions · Answer 3

I have solved this problem, without using external programs.

I have posted my stored procedure on the link below, it backups a SSAS database from a SQL Server server.