Limit Structures
Download sample file: limit_structures.csv
This file is used to create Limit Structures in bulk. For information on how to upload Limit Structures using this file, see Upload new limits.
| Column Name | Description | Required | Value Example |
|---|---|---|---|
| Group | Name of a group of limits. Group is a way of organizing similar limits. | N | Equity Desk |
| Structure ID | The ID of the structure. | Y | id_desk_00023 |
| Name | The KPI name created in the business Cube. | Y | Delta |
| Comment | Note about the limit. | N | This is a comment |
| Polling Frequency | Data time relevancy of the limit (End of day, Intraday). | Y | EOD |
| KPI Type | The type of KPI (supported types are Greater Than, Less Than). | Y | Greater Than |
| Absolute Value Indicator | Is the Limit Value an absolute value. | Y | false |
| Warning Threshold | Percent value from a breach where a user will receive a warning. | N | 10 |
| Measure Name | Measure of the KPI. | Y | PV |
| Scope Keys | The left-hand side of the Limit’s Scope or the Scope’s level value. | Y | Book |
| Limit Changes Workflow | Limit Change workflow type. The following approval types are available: - FourEyes - SixEyes - StraightThrough |
N | Four Eyes |
| Limit Changes Workflow Parameters | The party charged with reviewing a limit’s workflow. Potential options are USERS or MANAGERS. See APPROVERS and EXAMINERS. | N | Approvers=MANAGERS |
| Exception Workflow | Exception workflow type: the workflow that handles a limit with a BREACHED or WARNING status. | N | Exception |
| Utilization Dashboard ID | The ID of a utilization dashboard that may exist for the limit structure. The ID maps to a dashboard ID in the content server. | N | b3a |
| Cube Name | Name of the Cube for the KPI. | Y | Sensitivity Cube |
| Server Name | Name of the server the Cube is running. | Y | MR |
info
There is a one-to-one relationship between the limit structure’s name and the KPI created when a limit is added to the structure. Atoti Limits uses data validation to prevent multiple structures from having the same name.