Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Enterprise Sales Analytics > Process of Configuring Siebel Enterprise Sales Analytics for SAP R/3 >

Tracking Multiple Attribute Changes in Bookings

This task is a step in the Process of Configuring Siebel Enterprise Sales Analytics for SAP R/3.

When you modify the default VAR_BOOKING_ID column, the SQL statement is configured as follows for SAP R/3:

EXT_SALES_ORDER_NUM ||'~'|| TO_CHAR(EXT_SALES_ORDER_ITEM)||'~'|| EXT_MATERIAL_NUM||'~'||EXT_CLIENT_CODE

However, if you want to track changes based on more than one attribute, in the SQL statement you must concatenate the attribute column IDs in the VAR_BOOKING_ID column. For example, if you want to track changes in Salespersons and Sold-to-Customer, then concatenate the technical name IDs in the VAR_BOOKING_ID column as follows:

EXT_SALES_ORDER_NUM ||'~'|| TO_CHAR(EXT_SALES_ORDER_ITEM)||'~'|| EXT_MATERIAL_NUM||'~'||EXT_SALES_REP_NUM_VAR||'~'||EXT_CLIENT_CODE

To track dimensional attribute changes in bookings

1. In PowerCenter Designer, open the Configuration for SAP R/3 folder.
2. Open the MPLT_SAI_SALES_ORDLNS mapplet.
3. Double-click the EXP_SALES_ORDLNS Expression transformation to open the Edit Transformation box.
4. In the Ports tab, edit the expression for the VAR_BOOKING_ID port, and enter the ID of the attribute for which you want to track changes.

   If you want to track changes in multiple attributes, concatenate the IDs of all attributes and put the concatenated value in the VAR_BOOKING_ID column.

5. Validate and save your changes to the repository.