Using the Analysis Services Deployment Wizard
The Analysis Services Deployment Wizard uses the XML output files generated from a Microsoft SQL Server 2005 Analysis Services (SSAS) project as input files. These input files are easily modifiable to customize the deployment of an Analysis Services project. The generated deployment script can then either be immediately run or saved for later deployment.
You can deploy by using the wizard as discussed here. You can also automate deployment or use the Synchronize capability. If the deployed database is large, consider using partitions on target systems. You can also automate partition creation and population by using Analysis Management Objects (AMO).
Neither the XML output files nor the deployment script contains the user id or password if these are specified in either the connection string for a data source or for impersonation purposes. Since these are required for processing purposes in this scenario, you must add this information manually. If the deployment does not include processing, you can add this connection and impersonation information as needed after deployment. If the deployment includes processing, you can either add this information within the wizard or in the deployment script after it is saved.
In This Section
The following topics describe how to work with the Analysis Services Deployment Wizard, the input files, and the deployment script:
Describes the various ways in which you can run the Analysis Services Deployment Wizard.
Describes which files the Analysis Services Deployment Wizard uses as input values, what each of those files contains, and provides links to topics that describe how to modify the values in each of the input files.
Describes what the deployment script contains and how the script runs.