DimProcInfo Table

For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.

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.

See Also

Other Resources

Data Warehouse Report Tables