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

1. In PowerCenter Designer, open the Configuration for Universal Source folder.
2. Open the SDE_Universal_ExpenseFact mapping.
3. Select the Expression transformation to open the Edit Transformations box and select the Port tab.
4. Select the Add Port icon to add the PREF_MERCHANT_FLAG port.
5. Enter preferred merchant flag logic.
6. Validate the mapplet and click OK to exit.
7. Save your changes to the repository.