CubeProcInfo Table
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
The following table contains information that is used by the Report preparation DTS task to process cubes. This table should be updated when cubes are added or deleted. The CubeProcInfo table contains data relevant to the cube and is used to define partitions for the cube.
Attribute name |
Data type |
Constraint |
Default |
Description |
|---|---|---|---|---|
AutoPartition |
bit |
NOT NULL |
1 |
Indicates whether partitions will be added. If True (1), new partitions will be added to the cube as needed by the Report preparation DTS task. If False (0), partitions will not be automatically created for the cube. |
CubeName |
nvarchar (50) |
NOT NULL |
None |
Specifies the name of the cube to be processed. |
FactTable |
sysname |
NULL |
|
Specifies the name of the fact table associated with the cube name. |
IncEnabled |
bit |
NOT NULL |
None |
Indicates how the cube data will be processed. If True (1), the cube will be processed incrementally if the Report preparation DTS task is running in incremental mode. If False (0), data for the cube will always be fully refreshed when the Report preparation DTS task is run. |
IsVirtual |
bit |
NOT NULL |
0 |
Indicates whether the cube is virtual. If False (0), the cube is standard. If True (1), the cube is virtual. |
Optimization |
tinyint |
NULL |
|
Indicates the targeted optimization percentage for the Report preparation DTS task when it is run in full mode and aggregations are designed for the cube. If NULL, no aggregations will be designed. |
PartitioningKey |
sysname |
NULL |
|
Specifies the name of the column in the table defined in PartitionKeySource that will be used to partition data within the cube. This column is used by autopartitioning if the AutoPartition bit is set to 1. |
PartitionKeySource |
sysname |
NULL |
|
Specifies the name of the table that provides partition key values. |
PartitionSize |
Bigint |
NULL |
Validate that PartitionSize is greater than zero (0). |
Specifies the key range that will be covered by the next partition added to the cube by autopartitioning. |
ProcessingEnabled |
bit |
NOT NULL |
1 |
Specifies whether the cube will be processed. If True (1), the cube will be processed. If False (0), the cube will not be processed. |
ProcessingKey |
sysname |
NULL |
|
Specifies the name of the column in the table defined in ProcessingKeySource that will be used to identify new rows that have been added to this table. This column is used by incremental processing if the IncEnabled bit is set to 1. |
ProcessingKeySource |
sysname |
NULL |
|
Specifies the name of the table that provides processing key values. |
ProcessingPass |
int |
NOT NULL |
0 |
Specifies the processing pass to which this cube is assigned. The Report preparation DTS task groups cube processing operations into separate passes. All cubes in one pass are processed before cubes in the next pass are processed. |