CubePartitionInfo Table
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
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). |