Follow

Integration Configuration - Exception Query with Calendar Context

Limit exceptions that occur on measure values will also be available to be consumed by a consumer. In addition to the Measure Value replacement placeholders, Exceptions Queries may also be configured with placeholders where the respective limit values will be used to replace the configured placeholders.  All the measure value details are available along with the limit details.

Additional parameters that can be used as placeholders in database queries to insert or update data include:

  • [name]
This will be replaced by the name of the limit configured on the measure. If no value is found, it will be replaced by a blank string (“”).
  • [high]
This flag indicates that a high limit exemption occurred for the current time period interval. The value will be a Boolean (True/False). If no value is found or no high exception occurred, it will be replaced by a blank string (“”).
  • [low]
This flag indicates that a low limit exemption occurred for the current time period interval. The value will be a Boolean (True/False). If no value is found or no low exception occurred, it will be replaced by a blank string (“”).
   

If specified, the user query can be executed to update or add any user details after the execution of the limit exception query.

Note: For Time Periods and any string values, please remember to add single quotes (') to the placeholder parameters.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments