DimProcInfo Table
The following table contains information that the Report preparation DTS task uses to process shared dimensions. Update this table when you add or delete shared dimensions.
Attribute name |
Data type |
Constraint |
Default |
Description |
|---|---|---|---|---|
DimName |
nvarchar (50) |
NOT NULL |
None |
Contains the dimension name. |
IncEnabled |
bit |
NOT NULL |
1 |
Indicates how the dimension data will be processed. If True (1), the dimension will be processed incrementally. If False (0), the dimension data will always be fully refreshed, regardless of the task settings. |
LastSuccessfulDate |
datetime |
NULL |
None |
Indicates the date and time that the dimension was last processed successfully. |
LastProcessedDate |
datetime |
NULL |
None |
Indicates the date and time of the last attempt to process the dimension. |
LastProcessedDescr |
nvarchar (255) |
NULL |
None |
Contains text that describes the result of the last attempt to process the dimension. |
LastProcessedStatus |
int |
NULL |
None |
Contains the status of the last attempt to process the dimension. If 0, the cube was processed successfully. |
Ordinal |
int |
NULL |
None |
Specifies the order in which the dimension is to be processed by the Report preparation DTS task. |
ProcessingEnabled |
bit |
NOT NULL |
1 |
Specifies whether the dimension will be processed. If True (1), the dimension will be processed. If False (0), the dimension will not be processed. |