Limit Structures
This object contains the Limit Structures. This table branches off the Limits store, which contains individual Limits per Limit Structure.
Table name: LimitStructures
| Column | Key | Type | Description |
|---|---|---|---|
| Group | Y | string | Name of a group of limits. Group is a way of grouping similar limits together. |
| Comment | string | A description about the limit structure. | |
| Polling Frequency | string | How often to evaluate the limit. Can be End Of Day, Intraday, Daily, etc. See Alert Tasks for more info. | |
| System State | string | Optional field to note the state of the limit structure in the upstream system. | |
| Reference ID | Y | string | Identifier for this limit. A secondary way to group limits together or track a limit from an upstream system. |
| Limit Structure Name | Y | string | The KPI name to be created in the business cube. |
| Measure Name | Y | string | Name of the underlying Measure or Calculated Measure in the Business Cube. |
| Absolute Value Indicator | boolean | Specifies whether to use the absolute value of the underlying measure. For example, when enabled, a Greater Than limit on 10 will fail when a measures value is -11. | |
| Warning Threshold | integer | (Optional) The percentage within limit goal to trigger a Warning workflow. | |
| KPI Type | string | Type of KPI to be created. (Greater Than, Less Than). | |
| Precedence | string | Precedence of a limit to be applied to a Location. If two limits apply to a location in the Cube, Precedence can help to enforce which limit takes effect. | |
| User ID | string | ID or name of the user who created the limit. | |
| Cube Name | Y | string | Name of the Cube the limit is on. |
| Server Name | Y | string | Name of the Server the limit is on. |
| Timestamp | timestamp | The time the limit was created. | |
| limitKey | int | Unique identifier of this limit. | |
| Exception Status | string | Information on whether a limit was breached. | |
| Exception Category | string | Reason for the limit breach. Predefined list of reasons is set in the UI settings file: LimitsSettings.ts. Value is set in the Review dialog of the Breaches of a limit. See the Exception Status field in the Dimensions section for more. |
|
| Exception Comment | string | Comment attached to an Exception Workflow. | |
| Limit Changes Workflow | string | Type of workflow to use for changes to the limit. | |
| Limit Changes Workflow Parameters | string | Parameters of the workflow. Specifies the roles that can approve the workflow. | |
| Exception Workflow | string | Type of workflow to use for handling Breaches and Warnings. |