The Partition wizard helps you separate one logical cube into separate physical partitions so that you can enhance flexibility in data storage and location of data sources and 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 Partitions and its subtopics in the Administrator’s Guide.
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 approach enables you to fine-tune your cube by specifying different data storage modes (MOLAP, ROLAP, or HOLAP) and designing different aggregations for each partition.
To start the Partition wizard, expand your cube in the OLAP Manager tree view, right-click the Partitions folder, and then click New Partition.
Choose this option to bypass the wizard’s introductory step the next time you start the wizard. If you choose this option, you can return to the introductory step in the future by clicking Back in the second step of the wizard.
Choose this option to go to the next step of the wizard.
Choose this option to cancel the completion of the wizard and return to the OLAP Manager.
Choose this option to view this Help topic.