Adding new metric

To add a new metric:

  1. Click New. The new metric window is displayed.
  2. Provide a description for the metric that will be displayed in the Exception Browser of Infor Risk & Compliance. When providing the description, you can specify the token <CLASS> anywhere in the description string. This token will be replaced with the class name at runtime. For example, if the description is defined as <CLASS> creation trend, and if we are looking at an Invoice object, in the Exception Browser the description will be displayed as INVOICE creation trend. The Stored Procedure name is derived from the display name and displayed automatically. The stored procedure contains the logic to calculate the metrics.
  3. Click the Get Stored Procedure Template link, if you do not already have the Stored procedure template. When you click the link, the SQL gets copied to the clipboard. You can work with the stored procedure on the clipboard and then paste the template in any SQL editor using Ctrl V Alternatively, if you already have the Stored Procedure SQL, copy it in the Stored Procedure SQL field.
  4. Click Save. Based on the logic available in the stored procedure, the relevant information will be displayed on the L3 of the exception generated.