This object contains the limits. This table is the Base Table from which all other tables branch off. Multiple entries in the Limits table can correspond to a single entry in the LimitStructures table.
Table name: Limits
Column
Key
Type
Description
Structure ID
Y
string
The ID of the Limit Structure that this limit relates to.
Limit ID
Y
string
The ID of this limit.
Start Date
Y
date
Date the limit is valid from.
End Date
date
Date when the limit expires. No value means a limit is valid indefinitely.
Limit Type
Y
string
OFFICIAL or TEMPORARY tag on this limit.
Limit Values
list of double
Goal of the limit breach value(s). If a Greater Than or Less Than limit than there will only be one value.
Scope
Y
int
Location in the Business Cube to apply this limit. See Limit Scopes section for details.
Limit Status
string
The status of the limit that is in use.
note
A Pending Workflow does not affect this field until the Pending Workflow is Approved.
Source Limit ID
Y
string
The key of the source limit from which this limit was created. Technical field used by temporary Limits.
Precedence
string
Precedence of a limit to be applied to a location. If two limits apply to a location in the Cube, then the limit with higher precedence value is evaluated.
Alive *
boolean
Whether the Limit is still valid (not deleted or expired).
note
* This field is not required in the CSV source, as we expect any limit from this source to be valid. Therefore, any limit loaded from a CSV file will be set with the Alive field to true.