5.3.5.1.2.4 Search

The Search option allows you to search the Leaf values that have coefficient values defined on the Static Table Driver Definition page. This functionality works only if the Coefficient option is enabled. You can export this extracted list using the Export functionality.

To perform the search, perform the following steps:

1. Apply Filter to your required column within the Coefficient matrix. You can apply filtering to any number of columns.
2. Click Search.

   The selected Leaf values that match the filtering conditions are displayed in the grid. You can also export this list using the Export functionality.

3. Click Reset to remove the filter.

   Reset: The Reset option on the Static Table Driver Definition page removes any coefficient you may have specified, and refreshes the screen. It also allows you to reset the Search on the Static Table Driver Definition page.

   Example: For other uses, you may want only a subset of all possible combinations of Key Leaf values and Target Leaf values. For example, you may wish to allocate a series of Management Ledger balances from a cost center to another cost center. If you wanted to allocate balances from Company A to Cost Centers 1 and 2; and if you wanted to allocate balances from Company B to Cost Centers 2 and 3, then the values would be as follows:

   • Key Leaf dimension would be Organizational Unit
   • Key Leaf values would be Company A and Company B
   • Target Leaf dimension would also be an Organizational Unit
   • Target Leaf values would be Cost Centers 1, 2, & 3
   • Enabled combinations would be A-1, A-2, B-2, and B-3