Building and Saving a Report

Reports in Risk Analytics are highly customizable and enable you to report on any data that is passed to Risk Analytics.

In the Reports tab of Risk Analytics Presentation Service you can determine what you wish to report on.

You can for instance choose to look at certain criteria for given transactions on a certain date that are declined by a specific merchant. All reports you build can be saved and can either be displayed in the browser or downloaded as a CSV file. You can generate reports using different pre-defined models and previously saved queries as the report source (see Modify and re-run a saved report query).

The operations that are available for creating and modifying reports depend on the source model used to create the report!

To create reports from a model

1. In the database, create a dedicated table for the report model.

   This table must contain all the fields provided in Risk Analytics Presentation Service so that these can be included in the report. By default , Risk Analytics Presentation Service also offers you templates for standard tables that can be used for reporting, Transactions and Alerts.

2. In Risk Analytics Presentation Service, navigate to AUDIT & REPORT > Reports. Select and load the previously created model from the list in the Options section.

3. Add the relevant columns.

   You can add all columns from the model by selecting the check box next to the table name. To add model columns to the report, expand the parameters list of the loaded model by clicking on the table name or the + button. Select the check boxes of all required columns from the list and click Add Columns to take over your selection into the report. To add single columns individually, select Add column in the Columns panel and add the required column. Add further columns to the report as required.

4. Add conditions.

   To query a combination of several pending alerts in the report, you can add conditions to apply to the pending alerts. You can also select how these conditions will apply to the selected pending alert. To add a condition, click the hyperlink or the corresponding button at the end of the parameter list.

5. Select the nature of the condition, i.e. if all, any, not all, or none of the condition parameters will apply.

6. From the criteria list menu, select the required condition parameters.

7. (OPTIONAL) Click Add condition at the lower-right corner to obtain further criteria list menus for parameter selection, if necessary.

   1. Load the Transaction template.

   2. To determine which pending alert will be selected, select in the Entities options the database columns to be added to the report.

   3. Select the Add condition hyperlink.

   4. From the Conditions list menus, select AMT_CH_BILL and is_greater_than. Then enter 50 in the input field as the amount value.

   With this condition, you will query only transactions with an amount of USD50 with your report.

8. Determine the sort order for the columns of your report.

   The reporting function is an SQL-based procedure. In Risk Analytics Presentation Service, you can select how to order the columns you wish to add in the report. SQL logic in Risk Analytics Presentation Service reporting illustrates the SQL logic and its corresponding realization in the Risk Analytics Presentation Service reporting.

   

   SQL logic in Risk Analytics Presentation Service reporting

9. Enter a name for the report you created in the corresponding input field.

10. To save and/or preview the report query click Run and Preview. Alternatively, click Run and Export to export it as a CSV file.

    When running a preview, the number of displayed result lines is limited based on the Max Preview Results setting.