Bookshelf Home | Contents | Index | PDF | ![]() ![]() |
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 OptionThis 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. 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
|
![]() |
![]() ![]() |
Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide |