visual studio 2010 - Configuring deployment of SSAS multidimensional cube to different environments -


i have seen answer deploying ssas cube environments

which describes how deployment of ssas cube can automated, can't see how configure project able deploy multiple environments i.e. development, uat , production, each on different server , has different data source.

i can see in visual studio ssdt analysis services project configuration manager can used set multiple deployment configs in user specific!! .dwproj.user file.

this allows me set multiple ssas deployment locations , when building dev or uat etc.. .deploymenttargets file gets set correctly.

what doesn't allow me set different data source automatically during build auto change .configsettings file.

does know how this?

i believe dwproj file holds different sql connection strings per environment described here: http://www.artisconsulting.com/blogs/greggalloway/2008/3/19/analysis-services-project-configurations

i have seen bug when first set dwproj file never flagged dirty connection string changes never saved disk. if have issue add new role object delete it. marks dwproj file needing saved.


Comments