This file is used to create limits in bulk. For information on how to upload limits using this file, see Upload new limits.
Column Name
Description
Required
Value Example
Structure Group
Name of a group of limits. Group is a way of grouping similar limits.
Y
Equity Desk
Structure Name
The KPI name created in the business cube.
Y
Delta
Structure ID
The ID of the limit’s structure.
Y
id_00001
Cube Name
Name of the cube for the KPI.
Y
Sensitivity Cube
Server Name
Name of the server the cube is running.
Y
MR
Measure Name
Measure of the KPI.
Y
PV
Limit ID
ID for a given Limit.
Y
lim_00001
Limit Name
Name for a given Limit.
Y
SA Book Limit
Start Date
Effective Start Date.
Y
2020-01-01
End Date
Effective End Date.
N
2020-01-31
Limit Type
The type of limit: either OFFICIAL or TEMPORARY.
N
OFFICIAL
Limit Values
The value of the limit.
Y
100000
Scope
Specifies the members to which the new limit applies. Please see the Scope section for more information.
Y
Desk=Bonds|FI_HY_LEGACY
Limit Status
The limit’s status along the workflow.
Y
APPROVED
Source Limit ID
The key of the source limit from which this limit was created. Used by temporary limits to reference the original official limit.
N
12345678
Precedence
Used to override which limit in a limit structure is evaluated, regardless of scope. Not recommended for use unless absolutely necessary, as the scope should be sufficient. A higher value indicates higher precedence. The default is 0.