Create limit definitions

There are two ways you can create a new limit: you can create limits using the Limits Inventory UI, or you can upload limit definitions in a CSV file.

Create a new limit in the UI

To create a new limit definition, in the Limits Inventory, click the Create New Limit button and enter all the necessary information. Some information fields are required.

1. From the Limits Inventory widget, click Create New Limit. The Create New Limit panel is displayed.

2. In the Parameters section, enter information for the required fields.

Field Name	Description	Example
Name	The KPI name created in the business cube.	SA Desk Limit
Source ID	The Reference ID to the limits golden source upstream.	id_12345
Comment	Note about the limit.	This is a comment
Group	Name of a group of limits. Group is a way of grouping similar limits.	Equity Desk
Limit type	The type of limit: either OFFICIAL or TEMPORARY. These are categories with no logic or processing tied to them.	OFFICIAL
Valid from	Effective start date.	2020-01-01
Valid to	Effective end date.	2020-01-01
Polling frequency	How often should the limit be checked for a breach. If the value is Intraday, AlertTaskManager will schedule a future task. The frequency of evaluation can be changed in the limits.properties: task-scheduler-thread-pool-size=4 sample-rate-minutes=* sample-rate-seconds=0	Intraday

3. In the Limit Value section, select and enter information to define a scope for the limit:

Field Name	Description	Example
Server	The server where the limit is created.	MRA
Cube	Name of the business cube for the KPI/Limit.	Sensitivity Cube
Measure	Measure of the KPI.	FX Risk Charge
Rules	The KPI type. For details, see Select a rule.	Greater Than
Currency	Currency in which the value of the KPI is expressed. note The FX Conversion has not been implemented yet.	USD
Scope	This determines which members the new limit applies to. You can choose any level of the currently selected cube and a corresponding value from said level. An example scope filter is “Desk=Rates”. Multiple scope filters can be added to a single limit definition. Every scope filter is separated by a pipe. There is no limit on the amount of conditions that can be added to a limit’s scope. See Multiple level scope	Desk=Rates

4. In the Workflow section, select the type of workflow and the level of scrutiny for each workflow. The fields are:

Field Name	Description	Example
Limit Exception	Exception workflow type. The Exception workflow type defines the behavior for both limit breaches and warnings. In the reference implementation, the workflow is called ‘Exception’ and is defined in limit-process-exception.bpmn.
Limit changes	Limit changes and creation workflow type. This workflow is required for amending the limit value on a defined/approved limit. You can select the approval type: FourEyes, SixEyes or StraightThrough. When a limit is created in Limits Inventory, the Limit changes workflow is applied. When a limit is created through upload, the StraightThrough workflow is applied and the limit goes directly into “APPROVED” status.

The workflows that are part of the core solution are:

• StraightThrough: There is no approval needed.
• FourEyes: In addition to the person doing the action, another person needs to approve for the action to be effective. When this workflow is selected, you need to select an Examiners user group for approval.
• SixEyes: In addition to the person doing the action, Two other persons need to approve for the action to be effective. When this workflow is selected, you need to select an Examiners and Approvers user group for approval.

For details on extending the workflows, see Limit Workflow

5. Click Submit to create a new limit.

Select a rule

The supported KPI types are Greater Than and Less Than.

Examples:

• Greater Than: The KPI has a breach status when the measure value is greater than the specified value.

• Less Than: The KPI has a breach status when the measure value is less than the specified value.

When selecting a rule, a popup appears with the following fields:

Field Name	Description	Example
Value/Absolute Value	Whether the measure should be interpreted as an absolute value when comparing to limit value.	Value
Limit Value	The limit value used.
Warning when within	Enables or disables warning status when within % of breach limit value.	Disabled
Percent % of breach	A percent value which defines a percent threshold from our limit value which would return an amber status for our KPI. For a Greater Than limit, this will be the % of utilization where a warning is triggered. For example, on a limit where there is a breach at 10,000 and a warning at 90%, the warning will be triggered at 9,000. For a Less Than limit, this will be the % of the limit over the breach. For example, if a limit is defined as breaching when less than 10,000 and a warning of 10%, it will create a warning when the value is 11,000.

Here’s an example of using the Greater than rule:

Multiple level scope

Some levels, when displayed in a pivot table, will display all previous elements in the same hierarchy. These types of levels are called Parent-Child levels. For example, FRTB’s BookHierarchy consists of levels Level 1 through Level 15. If Level 5 is brought into a pivot table, levels Level 1 - Level 4 will populate the table as well.

This same behavior is supported when creating a limit’s scope. Using the previous example, if you select Level 5 as the level, and a member, all previous levels will automatically generate an individual scope.

The last level can be deleted from the final scope. This will also delete all of the corresponding generated scopes. You can also change the member value selected by clicking on the ‘filter’ button. Changing the member selected will update the last level, as well as all of the previously generated scopes.

Upload new limits

Another way to create limit definitions is to upload a CSV file within the Limits Inventory widget. For details on what the CSV file should contain, see Limits approve.

To upload limits:

1. Click Upload.
2. Choose a valid CSV file from your local drive and click Upload. The widget automatically updates and displays the newly uploaded limits.

A valid CSV file to upload has the following column order: Group, ID, Name, Comment, Start Date, End Date, Frequency Type, Polling Frequency, Ccy, Measure Name, Scope, Workflow Status, Warning Workflow, Warning Workflow Parameters, Breach Workflow, Breach Workflow Parameters, Limit Changes Workflow, Limit Changes Workflow Parameters, User ID, Cube Name, Server Name

Download Limits

You can also download limit definitions from the Limits Inventory widget. Click Download to download a CSV file of limit definitions into your browser. The CSV table downloaded contains the same columns and order as the table displayed within the Limits Inventory Widget. See Table columns for more details.

You can also download the CSV file by right-clicking anywhere within the Limits Inventory widget and select Export to CSV from the context menu. Both options display the CSV file in your browser.