Specify Partition Type (Partition Wizard)

Analysis Services

Analysis Services

Specify Partition Type (Partition Wizard)

In this step of the wizard, you specify whether the partition's data is stored on the local Analysis server or on a remote Analysis server.

You can change the options in this step only if you are creating a new partition. You cannot change them if you are editing an existing partition.

Options

Local

Select to store the partition's data on the local Analysis server (that is, the Analysis server on which the partition is being defined). This is the default option.

Remote

Select to store the partition's data on a remote Analysis server.

If a remote partition is defined on an Analysis server, the Analysis server service (MSSQLServerOLAPService) logon account must be a domain user account. Otherwise, processing the partition will fail. This restriction applies to the Analysis server on which the remote partition is defined, not the Analysis server in the Select the server this partition will reside on box.

Select the server this partition will reside on

Select the remote Analysis server on which to store the partition's data. Only registered Analysis servers appear in the box. Remote partitions on a server computer running SQL Serverâ„¢ 7.0 OLAP Services are not supported.

Register server

Click to display the Register Analysis Server dialog box in which you can register an Analysis server. To register an Analysis server, your user name must be included in the OLAP Administrators group on that Analysis server.

See Also

Introduction to Partitions

Managing Partitions

Partition Storage

Remote Partitions