DimProcInfo Table
The following table contains information used by the Report preparation DTS task to process shared dimensions. This table should be updated when shared dimensions are added or deleted.
| Attribute name | Data type | Constraint | Default | Description |
|---|---|---|---|---|
| DimName | nvarchar (50) | NOT NULL | None | Dimension name. |
| IncEnabled | bit | NOT NULL | 1 | 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 | Date and time that the dimension was last processed successfully. |
| LastProcessedDate | datetime | NULL | None | Date and time of the last attempt to process the dimension. |
| LastProcessedDescr | nvarchar (255) | NULL | None | Contains text describing the result of the last attempt to process the dimension. |
| LastProcessedStatus | int | NULL | None | 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 | If True (1), the dimension will be processed. If False (0), the dimension will not be processed. |
Copyright © 2005 Microsoft Corporation.
All rights reserved.