| title | Partition Wizard F1 Help (Analysis Services - Multidimensional Data) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 06/13/2017 | |
| ms.prod | sql-server-2014 | |
| ms.reviewer | ||
| ms.technology | analysis-services | |
| ms.topic | conceptual | |
| helpviewer_keywords |
|
|
| ms.assetid | 3b6d7053-aeef-4d9e-af70-f5b40256e859 | |
| author | minewiskan | |
| ms.author | owend | |
| manager | craigg |
You can use the Partition Wizard to define partitions for a measure group in a cube. By default, a single partition is defined for each measure group in a cube. Access and processing performance, however, can degrade for large partitions. By creating multiple partitions, each containing a portion of the data for a measure group, you can improve the access and processing performance for that measure group.
Caution
It is possible to create partitions that may contain incorrect data by including duplicate rows in the Specify Source Information or Restrict Rows pages.
The Partition Wizard guides you through the following steps:
-
Selecting the data source view for the partition.
-
Creating a filter for the records included in the partition.
-
Setting the processing and storage locations.
-
Naming and saving the partition.