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 limit structure. Group is a way of grouping similar limit structures together. |
Structure ID | string | Unique identifier of this limit structure. | |
Name | Y | string | The KPI name to be created in the Business Cube. |
Comment | string | A description of the limit structure. | |
Polling Frequency | string | How often to evaluate the limit structure. Can be End Of Day, Intraday, Daily, etc. See Alert Tasks for more info. | |
KPI Type | string | Type of KPI to be created. (Greater Than, Less Than). | |
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. | |
Measure Name | Y | string | Name of the underlying Measure or Calculated Measure in the Business Cube. |
Scope Keys | integer array | The ids of the scope keys used by limits in this limit structure, which are available in the scope keys store. | |
Limit Changes Workflow | string | Type of workflow to use for changes to the limit structure’s limits. | |
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. | |
Utilization Dashboard ID | string | The ID of a utilization dashboard that may exist for the limit structure. The ID maps to a dashboard ID in the content server. | |
Cube Name | Y | string | Name of the Cube the limit structure is on. |
Server Name | Y | string | Name of the Server the limit structure is on. |
System State | string | Optional field to note the state of the limit structure in the upstream system. | |
Timestamp | timestamp | The time the limit structure was created. | |
Exception Status | string | Information on whether a limit structure was breached. |