Rename SSAS databases with Powershell
We had a challenge to keep our SSAS Cube always in browsable state as users are spread across the globe and we hardly find a window to deploy our changes and process quickly. To intensify the problem state, the cube we have is very big in size and to add to the problems the cube should undergo enhancements at least once a week.. We evaluated few options and zeroed down the option of having a redundant cube database, deploy changes and process it and finally swap the SSAS databases. The approach seemed fine and quickly we were able to host a second database and swap it with the original one using XMLA script.
Read more...Tags: amo, script, powershell