The W_SALES_BOOKING_LINE_F table tracts changes in SALES_QTY,
NET_AMT, and certain attributes defined in BOOKING_ID column. BOOKING_ID
is calculated in SDE mappings of Sales Order Line table as follows:
-
For SDE_ORA11510_Adaptor and SDE_ORA12Version_Adaptor:
TO_CHAR(SQ_BCI_SALES_ORDLNS.LINE_ID)||'~'||TO_CHAR(SQ_BCI_SALES_ORDLNS.INVENTORY_ITEM_ID)||'~'||TO_CHAR(SQ_BCI_SALES_ORDLNS.SHIP_FROM_ORG_ID)
-
For SDE_FUSION_V1_Adaptor:
TO_CHAR(SQ_FULFILLLINEPVO.FulfillLineId)||'~'||TO_CHAR(SQ_FULFILLLINEPVO.FulfillLineInventoryItemId)||'~'||TO_CHAR(SQ_FULFILLLINEPVO.FulfillLineFulfillOrgId)
However, if you want to track changes on another attribute, then you
must concatenate the source column of the attribute with the default
mapping expression. For example, if you want to track changes in
Customer Account, then concatenate the source column of Customer Account
in the BOOKING_ID column as follows:
-
For SDE_ORA11510_Adaptor and SDE_ORA12Version_Adaptor:
TO_CHAR(SQ_BCI_SALES_ORDLNS.LINE_ID)||'~'||TO_CHAR(SQ_BCI_SALES_ORDLNS.INVENTORY_ITEM_ID)||'~'||TO_CHAR(SQ_BCI_SALES_ORDLNS.SHIP_FROM_ORG_ID)||'~'||TO_CHAR(INP_CUSTOMER_ACCOUNT_ID)
-
For SDE_FUSION_V1_Adaptor:
TO_CHAR(SQ_FULFILLLINEPVO.FulfillLineId)||'~'||TO_CHAR(SQ_FULFILLLINEPVO.FulfillLineInventoryItemId)||'~'||TO_CHAR(SQ_FULFILLLINEPVO.FulfillLineFulfillOrgId)||'~'||TO_CHAR(SQ_FULFILLLINEPVO.HeaderSoldToCustomerId)
To track multiple dimensional attribute changes in bookings:
-
In ODI Designer Navigator, open the SDE_ORA11510_Adaptor, SDE_ORAR12Version _Adaptor, or SDE_FUSION_V1_Adaptor folder.
-
Open the main interface of SDE mappings of Sales Order Line table:
-
SDE_ORA_SalesOrderLinesFact.W_SALES_ORDER_LINE_FS
-
SDE_FUSION_SalesOrderLinesFact.W_SALES_ORDER_LINE_FS
-
Find BOOKING_ID column and modify the mapping expression as described above.
If you want to track changes in multiple attributes, then you must concatenate all source columns of the attributes.
-
Save your changes to the repository.
No comments:
Post a Comment