Specifying Configuration Settings for Solution Deployment
Applies To: SQL Server 2016
The Analysis Services Deployment Wizard reads the partition and role deployment options that you use in the deployment script from the <project name>.configsettings file. SQL Server Data Tools (SSDT) creates this file when you build the Microsoft SQL Server Analysis Services project. SQL Server Data Tools (SSDT) uses the configuration settings of the current project to create the <project name>.configsettings file.
The following are the configuration settings stored in the <project name>.configsettings file:
Data Source Connection Strings These are the connection strings for each data source based on the values specified in the Analysis Services project. The user id and password are always removed from the connection string before the remainder of the string is stored in this file. However, if the Deployment Wizard is deploying directly to an Analysis Services instance, you can add the appropriate user id and password information within the wizard to enable a successful processing of the deployment database. This connection information will not be stored in the deployment script itself if one is saved by the Deployment Wizard.
Impersonation Accounts This setting specifies the user name that Analysis Services uses to run statements in each data source. If no impersonation account is specified, Analysis Services uses its logon account to run statements. If the Analysis Services logon account is granted permissions directly in the data source, all database administrators in all databases in the Analysis Services instance have access to the data source through the logon account. If a user account and password is specified, this information is always removed before the impersonation information is stored in this file. However, if the Deployment Wizard is deploying directly to an Analysis Services instance, you can add the appropriate user id and password information within the wizard to enable a successful processing of the deployment database. This impersonation information will not be stored in the deployment script itself if one is saved by the Deployment Wizard.
Key Error Log Files This setting specifies the file name and path of the key error log file for each cube, measure group, partition, and dimension in the database.
Storage Locations This setting specifies the storage location for each cube, measure group, and partition in the database. If no value is provided for an object, the Analysis Services Deployment Wizard uses the default location for the object. For example, partitions use the location for the measure group, measure groups use the location for the cube, and cubes use the default location for objects on the Analysis Services instance. The storage location can be a local or a Universal Naming Convention (UNC) path.
Report Server This setting specifies the report server and folder location for each report action defined in each cube in the database.
In some cases, you may need to deploy the Analysis Services project using different configuration settings than those stored in the <project name>.configsettings file. For example, you may want to change the connection string to one or more data sources, or specify storage locations for specific partitions or measure groups.
To modify the deployment of partitions and roles in an Analysis Services project, you must change this information within the <project name>.configsettings file, as described in the procedure below. You cannot change the partition and roles settings within the project because the <project name> Properties Pages dialog box in SQL Server Data Tools (SSDT) does not display these options.
Run the Analysis Services Deployment Wizard interactively, and on the Configuration Settings page, specify the configuration setting for the objects being deployed.
Run the Analysis Services Deployment Wizard at the command prompt and set the wizard to run in answer file mode. For more information about answer file mode, see Running the Analysis Services Deployment Wizard.
Modify the <project name>.configsettings file by using any text editor.