Processing and Storage Locations (Partition Wizard)

Use the Processing and Storage Locations page to specify the Microsoft SQL Server Analysis Services 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.