ACL GRC Analytics Exchange 13 Release Notes

ACL GRC Analytics Exchange 13 includes upgrades to Apache TomEE and PostgreSQL, and includes support for new ACLScript functionality released with ACL Analytics 13.

Software release November 2017

Patch release 13.0.1 December 2017

Patch release 13.0.3 April 2018

Patch release 13.1 August 2018

Patch release 13.1.1 September 2018 (if you have not installed the 13.1 patch, running the 13.1.1 patch includes the 13.1 updates)

New

• New system variable AXRunByUser available in scripts and stores the user name of the account that runs the analytic in the format "domain\username".
• APPEND command that combines records from multiple tables into a new table.
• New ACL Connectors for importing data from the following external sources:
  • Active Directory
  • Email
  • Exchange
  • Twitter
  • ServiceNow
  • MySQL
• Classical variables sampling (CVS) with stratified populations (CVSPREPARE, CVSSAMPLE, CVSEVALUATE)
• RCOMMAND that passes a list of fields to an external R script for analysis and creates a new table in ACL.

Enhanced

• Import multiple Excel worksheets using a single IMPORT command.
• The ALLFIELDS parameter has been added to the IMPORT EXCEL command, allowing you to import all fields in an Excel worksheet without having to define them individually.
• The Presort option on the Join command now uses the specified-field approach to sorting introduced in ACL 12.5.
• Cross-tabulating now supports numeric key fields. Previously only character key fields were supported.
• R functions now accept variables when specifying the R script or R code to run.
• Connections to Concur now include a User Param setting that imports data from the expense module for specific user accounts, or for all accounts.