Share via


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.