A distributed partitioned cube is a regular cube that utilizes remote partitions, distributing query and processing workload across multiple Analysis servers.
The procedure used to create a distributed partitioned cube starts with the creation of a regular cube. To create a regular cube, use either the Cube Wizard or Cube Editor.
To start the Cube Wizard
To build a cube with Cube Editor
Once the regular cube is created, remote partitions can be created for the cube with the Partition Wizard.
To start the Partition Wizard
In the Partition Wizard, use the Specify the partition type step to specify local or remote storage for the new partition. To create a remote partition, select Remote. Next, either select the registered remote Analysis server from the Select the server this partition will reside on drop-down list, or click the Register server button to register a new remote Analysis server.
Important To create remote partitions, the logon account for the Analysis server service (MSSQLServerOLAPService) must be a domain user account.