Selecting Transaction Properties for Import

  • Article

You use the TransDimension table in the Commerce database to select which transaction properties are imported into the Data Warehouse during the Transaction Data Import DTS task.

This procedure assumes that both the Commerce database and the Data Warehouse have been extended with a new column in the OrderformHeader, OrderformLineItems, OrderGroup or OrderGroupAddresses tables. The name of the extended table in the Commerce database must match the name of the extended table in the Data Warehouse. The name of the column added to each table must also match.

To select transaction properties to be imported into the Data Warehouse by the Transaction data import DTS task

  1. Click Start, point to Administrative Tools, and then click Commerce Server Manager.
  2. In Commerce Server Manager, expand Commerce Server Manager, expand Microsoft SQL Server, expand SQL Server Group, expand the node for the local server, expand Databases, expand the Commerce database, for example Retail_commerce, and then click Tables.
  3. In the Commerce Server Manager content pane, right-click TransDimension, point to Open Table, and then click Return all rows.
  4. The last row of the table is blank. Enter the following data in the last row:
    Column name Entry 
    DimensionName
    		 Type the name of the new column. 
    FieldName
    		 Type the name of the new column. 
    CategoryName
    		 Type the name of the extended table. 
    KeyField
    		 0 
    RequiredDim
    		 1
  5. Click the ! button on the toolbar to save your changes.

The next time the Transaction data import DTS task is run, data stored in the extended column of the Commerce database is imported to the extended column of the Data Warehouse.

Copyright © 2005 Microsoft Corporation.
All rights reserved.