Using AMO to administer MSAS cubes
I've recently been looking into using AMO to automate common configuration tasks to our MSAS cube infrastructure. In our production environment, we have multiple copies of cubes and multiple servers on which they're stored so minimizing manual tasks was a must. Sure, all of what is being described below can be done using a combination of BIDS and SSMS, but we have our own reasons for not following them in a live environment just as you will have yours. Therefore, we came up with the idea for a tool which could do the heavy lifting for us. AMO seemed like the obvious choice at first, until I started playing with it and realized how incredibly unintuitive it is until you really know how to use it.
Read more...Tags: management, amo, script