SQL Rule messages can be used to validate input parameters and highlight issues in a clear way for end users. You can define custom messages to return on Rule execution by using the SQL PRINT function. When users run the Rule, they will receive their message from a dialog window.
For example, the following message is returned when the bottom-up calculation Rule runs:
To configure a SQL Rule message, simply specify the message in a format similar to the following in the Rule Editor:
N'<INFO>Top down allocation completed'
N'<SUCCESS>Top down allocation completed'
N'<WARNING>Top down allocation encountered a warning on execution'
N'<ERROR>Top down allocation encountered an error on execution'
The <INFO>, <SUCCESS>, <WARNING>, and <ERROR> tags indicate the type of message displayed. In addition, any error messages that are encountered during Rule execution will stop any subsequent Rules, if any, from running.