Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Supply Chain Analytics > Process of Configuring Siebel Supply Chain Analytics for Oracle 11i >

Configuring the Left Bound and Right Bound Calculation Option

This task is a step in the Process of Configuring Siebel Supply Chain Analytics for Oracle 11i.

You can use the left bound and the right bound calculation to expedite some reporting requirements. For example, you can find the components in a subassembly within a finished product. Left bound and right bound are stored in the IA_BOM_ITEMS table for each BOM node, and they have one row of data in the IA_BOM_ITEMS table. The COMPUTE_BOUNDS stored procedure traverses the exploded BOM tree structure and calculates the left bound and right bound. By default, the COMPUTE_BOUNDS stored procedure is off and the IA_BOM_ITEMS.LEFT_BOUNDS and IA_BOM_ITEMS.RIGHT_BOUNDS columns are empty.

Figure 58 illustrates a sample BOM structure with the left bound and right bound values listed for each node. To find all the components under node B, you select the components with a top product key value of A, the left bound value is greater than 2, and the right bound value is less than 17.

Figure 58. Sample BOM Structure

You can use the following procedure to turn on the left bound and the right bound calculation and populate the IA_BOM_ITEMS.LEFT_BOUNDS and IA_BOM_ITEMS.RIGHT_BOUNDS columns.

To configure the left bound and right bound calculation option

1. In PowerCenter Designer, open the Configuration for Oracle Applications v11i folder.
2. Open the M_I_BOM_ITEMS_LOAD mapping.
3. Double-click the COMPUTE_BOUNDS stored procedure transformation to open the Edit Transformations dialog box, and click the Properties tab.
4. Change the value for Transformation Attributes Call Text to compute_bounds_ora11i(1).
5. Click Apply.
6. Validate the mapping, and save your changes to the repository.