CubePartitionInfo Table
The CubePartitionInfo table defines the actual partitions within the cube and is used to track the processing state of data within the cube.
| Attribute name | Data type | Constraint | Default | Description |
|---|---|---|---|---|
| CubeName | nvarchar (50) | NOT NULL | Specifies the name of the cube to be processed. | |
| LastKeyProcessed | Sql_variant | NULL | Contains the maximum value of the fact table ProcessingKey that was added to this partition. | |
| LastProcessedDate | datetime | NULL | Contains the datetime at which the last attempt to process the partition was made. | |
| LastProcessedDescr | nvarchar (255) | NULL | Contains text describing the result of the last attempt to process the partition. | |
| LastProcessedStatus | int | NULL | Contains the status of the last attempt to process the partition. Zero (0) for success. | |
| LastSuccessfulDate | datetime | NULL | Contains the datetime of the last successful attempt to process the partition. | |
| MaxVal | Sql_variant | NOT NULL | The maximum value for partitioning column values. Fact table rows with partitioning column values equal to or less than this value will be added to the partition. | |
| MinVal | Sql_variant | NOT NULL | The minimum value for partitioning column values. Fact table rows with partitioning column values equal to or greater than this value will be added to the partition. | |
| PartitionId | int | NOT NULL | Used internally to assign sequential partition names. This value does not necessarily correspond with the partition ordinal within the cube. | |
| PartitionName | nvarchar(50) | NOT NULL | Specifies the name of the partition to be processed. | |
| ProcessingEnabled | bit | NOT NULL | 1 | If True (1), the cube will be processed by the Report preparation DTS task. If False (0), the cube is not processed. |
| ProcessingState | int | NULL | 0 | Used internally by the Report preparation DTS task. If set to True (1), the processing state of the partition is indeterminate. All data within a partition will be refreshed if the ProcessingState is set to True (1). |
Copyright © 2005 Microsoft Corporation.
All rights reserved.