Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle Order Management and Fulfillment Analytics Option > Process of Configuring Oracle Order Management and Fulfillment Analytics Option for Oracle 11i >

Tracking Multiple Attribute Changes in Bookings

This task is a step in the Process of Configuring Oracle Order Management and Fulfillment Analytics Option 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 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_CUSTOMER_ID)

To track dimensional attribute changes in bookings

1. In PowerCenter Designer, open the SDE_ORA115<ver>_Adaptor folder.
2. Open the mplt_SA_ORA_SalesOrderLinesFact 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.