Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring Oracle's Supply Chain Analytics family of products > Process of Configuring 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 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 W_BOM_ITEM_F table for each BOM node, and they have one row of data in the W_BOM_ITEM_F 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 W_BOM_ITEM_F.LEFT_BOUNDS and W_BOM_ITEM_F.RIGHT_BOUNDS columns are empty.

Figure 26 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 26. Sample BOM Structure

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

To configure the left bound and right bound calculation option

1. In PowerCenter Designer, open the SDE_ORA115<Ver>_Adaptor.
2. Open the SIL_BOMItemFact 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.