Processing and Storage Locations (Partition Wizard)
Use the Processing and Storage Locations page to specify the Microsoft SQL Server 2005 Analysis Services (SSAS) instance of the cube that owns the partition, as well as the Analysis Services instance that stores the data for the partition. You can define a partition as a remote partition by specifying either a remote Analysis Services instance or a storage location other than the default storage location. For more information about remote partitions, see Remote Partitions.
Processing location Options
- Current server instance
Makes the current Analysis Services instance responsible for processing the partition.
Remote Analysis Services data source
Makes a remote Analysis Services instance responsible for processing this partition.From the dropdown list, select the data source representing the remote Analysis Services instance that will be responsible for processing the partition.
Note
An error occurs if you select a data source in which the Initial Catalog connection string property is not set to a valid Analysis Services database, or if the database specified in the Initial Catalog connection string property does not support remote partitions (in other words, the MasterDatasourceID property of the specified database is not set to a valid value).
- New
Creates a new data source representing the remote Analysis Services instance responsible for processing the partition.
Storage location Options
- Default server location
Makes the data folder of the current Analysis Services instance the storage location of the aggregation and indexing data for the partition.
- Specified folder
Specifies the storage location of the aggregation and indexing data for the partition.
- ...
Displays the Browse for Remote Folder dialog box in which you can select a folder for Specified folder.
See Also
Reference
Partition Wizard F1 Help (SSAS)
Browse for Remote Folder Dialog Box (SSAS)
Other Resources
Partitions (Analysis Services)
Defining and Configuring a Partition