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 Default Expense Distribution Percentage

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

At times, employee expenses may be distributed across multiple cost centers. For example, technical support associates frequently travel to work in an office with many cost centers; their expenses could be split between those who used their services. This cost center distribution is expected as a percentage from the source system or file; if it is not present a null value is returned. However, this prevents further calculations, so it is preferable to configure the default to be 100% if only one cost center is charged, rather than allow the system to return a null value.

To configure the default expense distribution percentage

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. Add a port named DIST_PERCENTAGE = <expression that sets this to 100%>.
5. Validate your mapplet.
6. Save your changes.