"Deploy MDX script" via PowerShell or other command line type interface

Sep 21, 2015 at 1:38 PM
It's easy to deploy the MDX script from within VS but I don't personally have permission to deploy anything in our production environment. Is there some way to do this that I can pass on to our DBAs for deployment so they don't have to use VS?

Sep 22, 2015 at 12:21 AM
Yes you can generate a script like this. Assuming that you've deployed from Visual Studio to a dev / test environment where you could confirm that the calculations work as expected you could then use a Powershell script like the one in this gist https://gist.github.com/dgosbell/83c4806ef5baaad2fc87 to generate an XMLA Alter command that could be run by your DBAs.