How do we automate SSAS Project configs such that (a) RDBMS data source server (connection) and (b) SSAS deployment target server are dynamic?
As it stands, just before I script the ASDB (for deployment/promotion from Dev to QA, or QA to Prod, for example), I use BIDS designer interfaces to change the source connection and deployment targets, then script the ASDB.
Is there a more dyamic alternative? Perhaps something analogous to SSIS package configurations? I can't believe that everybody is doing this as manually as I've done.
View Complete Post