Defining Threshold Sets Using Bulk Upload

Using Bulk Upload, threshold sets for several pipelines can be defined all at once in one single file. This streamlines the operation of threshold values definition.

To use bulk upload, follow these steps:

Note:

This functionality does not update existing values in a threshold set, but only allows you to define values of a new threshold set.

1. Navigate to the Threshold Editor page.
2. Click Add in the top right corner, then select Bulk Upload. The Bulk Upload Module window displays.
3. Select the scenario or scenarios you want to define threshold sets for from the Scenario drop-down list.
4. Click Download Template.An .xls file is downloaded which contains the threshold set details for the selected scenario(s).
5. Navigate to the folder where you saved the template file and open the template. If you have selected more than one scenario, each threshold set displays in a separate sheet of the file. The Scenarios to Sheet Mappings sheet details which sheet should be used for each scenario.
6. Provide the desired values for each parameter listed in the sheet using the Value field. Do not change the details or order of any fields in this sheet other than the Value field.
   • The Threshold Name must be unique in the system.
   • A valid Jurisdiction must be provided. Jurisdiction refers to the division of data in the database based on criteria such as geographical boundaries, legal entities, and so on.
   • Select the Period Type used in this threshold set using the drop-down list. Options include Days or Months. By default, the period type is Days.

     Note:

     Not all scenarios support a configurable Period Type. Before editing this field, verify the scenario supports a configurable Period Type at Scenarios Supporting Configurable Period Type. Scenarios not listed must be run with the Period Type as designed and defined in the TSD.

     Both the Lookback Period and Frequency Period use the same unit.

     For "Structuring" scenarios, the Period Type is applied for both Lookback and Frequency periods, transactions are processed by days (within period).

   • Enter the Lookback Period for this threshold set. Lookback period refers to the number of days or months to lookback from the current date or time to create a time window which is used to consider cases for correlation.
   • Enter the Frequency Period for this threshold set. Frequency period refers to how frequently the scenario should be run. A whole number (no decimals) must be provided in the Value field.
   • For parameters which use the NUMBER data type, Values may not exceed 23 characters. For parameters which use the STRING data type, Values may not exceed 1000 characters.
   • Up to 10 additional values may be added to each parameter as needed. Add Value as a heading to the columns right of Column D and provide the desired values.
7. When you have added values for all thresholds in the sheet, Save the template.
8. In the Bulk Upload Module window of the Threshold Manager, use the Scenario drop-down list to select the scenario or scenarios you provided threshold sets for.
9. Click Upload File. Select the template you have saved for upload and click Save. The file uploads and a confirmation message displays. The newly created threshold set is listed in the Threshold Set page.

   Note:

   If you attempt to upload a template for an existing threshold set, an error message displays.
10. Follow the steps in Running Existing Threshold Sets to run a simulation for the uploaded scenario threshold sets and verify your threshold settings.