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 Customer Billable Indicator


This task is a step in the Process of Configuring Supply Chain Analytics for a Universal Source.

The Oracle Business Analytics Warehouse provides a customer billable indicator that registers whether an expense item is billed to a customer or paid by your organization. The flag can have only one value—Y (cost is passed to the customer) or N (cost is paid by your organization). If you use custom logic to determine customer billable status, you must include that logic in the expenses Source Adapter.

To configure the customer billable indicator

  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.

    Add a port called CUST_BILLABLE_FLG = <insert your expression here>.

  4. Validate the mapplet and click OK to exit.
  5. Save your changes to the repository.
Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.