Oracle® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle's Supply Chain Analytics family of products > Process of Configuring Supply Chain Analytics for a Universal Source >
Configuring the Preferred Merchant Flag
This task is a step in the Process of Configuring Supply Chain Analytics for a Universal Source. The Oracle Business Analytics Warehouse provides a preferred merchant flag to indicate whether the requestor used a preferred merchant for an expensed item. The flag can have only one value—Y (item acquired from a preferred merchant) or N (item acquired from a merchant not recorded). If you use custom logic to determine merchant status, you must include that logic in the expenses Source Adapter. To configure the preferred merchant flag
- In PowerCenter Designer, open the Configuration for Universal Source folder.
- Open the SDE_Universal_ExpenseFact mapping.
- Select the Expression transformation to open the Edit Transformations box and select the Port tab.
- Select the Add Port icon to add the PREF_MERCHANT_FLAG port.
- Enter preferred merchant flag logic.
- Validate the mapplet and click OK to exit.
- Save your changes to the repository.
|