Remote Partitions - Advanced Settings Dialog Box (Analysis Services - Multidimensional Data)
Use the Remote Partitions - Advanced Settings dialog box in SQL Server Management Studio to edit advanced settings, such as the connection string of the data source representing the remote Analysis Services database maintaining remote partitions, while restoring remote partitions from a remote backup file to an Analysis Services database by using the Restore Database dialog box. You can display the Remote Partitions - Advanced Settings dialog box from the Partitions page of the Restore Database dialog box by clicking the ellipsis button (...) for a remote partition after selecting the Restore remote partitions option.
Data source name
Displays the name of the data source that represents the remote Analysis Services database that manages the listed remote partitions.
Displays the name of the remote backup file that contains the data to be restored for the listed remote partitions.
Displays the connection string for the data source displayed in Data source name.
Click to display the Data Link Properties dialog box and edit the properties contained in the connection string.
Select to specify different locations in which to restore remote partitions.
The following grid, enabled when this option is selected, is used to specify a restoration folder for each remote partition: