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 date and time at which the last attempt to process the partition was made. |
LastProcessedDescr |
nvarchar (255) |
NULL |
|
Contains text that describes 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) indicates success. |
LastSuccessfulDate |
datetime |
NULL |
|
Contains the date and time of the last successful attempt to process the partition. |
MaxVal |
sql_variant |
NOT NULL |
|
Contains 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 |
|
Contains the minimum value for partitioning column values. Fact table rows with partitioning column values equal to or larger 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 |
Indicates whether the cube will be processed. 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 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). |