CubeProcInfo Table
The following table contains information used by the Report preparation DTS task to process cubes. This table should be updated when cubes are added or deleted.
Attribute name | Data type | Constraint | Default | Description |
---|---|---|---|---|
AutoPartition | bit | NOT NULL | 1 | If set to True (1), new partitions will be added to the cube as needed by the Report preparation DTS task. If set to False (0), partitions will not be automatically created for the cube. |
CubeName | nvarchar (50) | NOT NULL | None | Name of the cube to be processed. |
FactTable | Sysname | NULL | Name of the fact table associated with the cube name. | |
IncEnabled | bit | NOT NULL | None | If True (1), the cube will be processed incrementally if the Report preparation task is running in incremental mode.
If False (0), data for the cube will always be fully refreshed when the Report preparation task is run. |
IsVirtual | bit | NOT NULL | 0 | If False (0) the cube is standard. If True (1) the cube is virtual. |
Optimization | tinyint | NULL | Indicates targeted optimization percentage for the Report preparation DTS task when run in full mode and aggregations are designed for the cube. If set to NULL, no aggregations will be designed. | |
PartitioningKey | Sysname | NULL | Specifies the name of the column in the table defined in PartitionKeySource, which will be used to partition data within the cube. This column is used by auto-partitioning 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 auto-partitioning. |
ProcessingEnabled | bit | NOT NULL | 1 | 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, which 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 | 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. |
Copyright © 2005 Microsoft Corporation.
All rights reserved.