Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Enterprise Sales Analytics > Process of Configuring Siebel Enterprise Sales Analytics for Oracle 11i >

Tracking Multiple Attribute Changes in Bookings

This task is a step in the Process of Configuring Siebel Enterprise Sales Analytics for Oracle 11i.

When you modify the default VAR_BOOKING_ID column, the SQL statement is configured as follows for Oracle 11i:

TO_CHAR(INP_LINE_ID)||'~'||TO_CHAR(INP_INV_ITEM_ID)||'~'||to_char(INP_WAREHOUSE_ID)

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:

TO_CHAR(INP_LINE_ID)||'~'||TO_CHAR(INP_INV_ITEM_ID)||'~'||TO_CHAR(INP_WAREHOUSE_ID)||'~'||TO_CHAR(INP_SALESREP_ID)||'~'||TO_CHAR(INP_SHIP_TO_SITE_USE_ID)

To track dimensional attribute changes in bookings

1. In PowerCenter Designer, open the Configuration for Oracle Applications v11i 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.