How to Select Transaction Properties for Import
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
You use the TransDimension and TransCategory tables in the transactions database to select which transaction properties are imported into the Data Warehouse during the Transaction data import Data Transformation Services (DTS) task.
To copy data from a new orders runtime table or view to the Data Warehouse
Open SQL Server Enterprise Manager, SQL Server Management Studio, or SQL Server Management Studio Express.
Expand the transactions database.
Open the TransCategory table.
Add a new row to the table, and provide the following values for the columns.
Column name
Entry
CategoryName
The name of the Data Warehouse class to create.
TableName
The name of the table or view in the transactions database.
Click ! to save your changes.
To export new columns from an orders runtime table or view
Open SQL Server Enterprise Manager, SQL Server Management Studio, or SQL Server Management Studio Express.
Expand the transactions database.
Open the TransDimension table.
Add a new row to the table, and provide the following values for the columns.
Column name
Entry
DimensionName
The name of the column in the Data Warehouse.
FieldName
The name of the column in the Commerce Server runtime table or view. This name must match a value in the TableName column in the TransCategory table.
CategoryName
The name of the Data Warehouse class. This name must match a value in the CategoryName column in the TransCategory table.
KeyField
True if the column being exported is a key column; False otherwise. If you are adding data for one of the existing classes, this value should be False.
RequiredDim
True if a value for this column must exist in the transactions database; False otherwise.
Click ! to save your changes.
If you extended one of the existing tables in the transactions database, add the new column to the csv_OrderFormHeader, csv_OrderFormLineItems, csv_OrderGroup, and csv_OrderGroupAddress views as needed.
The next time that the Transaction data import DTS task is run, data that is stored in the tables or columns of the Commerce Server database is imported to the extended class and column of the Data Warehouse.
See Also
Other Resources
Specifying Data to be Imported into the Data Warehouse