Limits

Download sample file: limits_approve.csv

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 Reference ID The Reference ID to the Limits Golden Source Upstream for the evaluation’s corresponding 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 eval_id_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 Array of KPI values in the specified currency. Y [100000,5000]
Scope Specifies the members to which the new limit applies. 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. Y Desk=Bonds|Book=FI_HY_LEGACY
Limit Status The limit’s status along the workflow. Y APPROVED
parentLimitKey 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. Y 0