Hey BABs,

As far as migrating from DEV to PROD, there's a few options. You could archive the database on the dev server, and then restore it to the Prod server. This works well, but something that really annoys me is that you can't rename your data source after doing this, so if your machines are named like some of ours (e.g. ABCDEV001) you end with a data source in PROD with a name that looks like it's refering to the dev datasource.

If you can see/manage both servers from your AS management console, you could just copy and paste items from server:catalog1 to server2:catalog1.

Management of the AS server and catalogs/cubes should probably fall under whoever is managing your EDW (I guess thats an assumptionthat you have one). In the case that you don't have a warehouse team, you will want to assign it to someone who will actually take some time on it. Dependant on your cube design (which is driven somewhat by your data sources), your cubes may not be overly self-reliant. For e.g. if you have partitions, one for each year of data, at some point you'll need to roll into the next/new partition as a year end comes around. Again, it's design dependant but there's quite a few things like that that need some level of monitoring/management.

HTH,

Steve