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.
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.