Introduction (Partition Wizard)
Use this wizard to separate one logical cube into separate physical partitions. Using partitions can enhance flexibility in data storage and data source location, and can also improve query performance. The wizard also helps you add partitions to cubes.
Caution It is possible to create partitioned cubes that contain incorrect data. For more information, see Managing Partitions.
You can partition data on different servers (using multiple data sources). This approach provides parallel query processing for one cube across a cluster of servers.
You can also separate data into multiple partitions on a single server (using a single data source). This enables you to fine-tune your cube by specifying different data storage modes—multidimensional OLAP (MOLAP), relational OLAP (ROLAP), or hybrid OLAP (HOLAP)—and designing different aggregations for each partition.
To start the Partition Wizard, expand your cube in the Analysis Manager tree pane, right-click the Partitions folder, and then click New Partition.
Options
Skip this screen in the future
Select this check box to bypass the wizard's introductory step the next time you start the wizard. If you select this option, you can return to the introductory step in the future by clicking Back in the second step of the wizard.