Release history - Caseware AnalyticsAI
The following highlights the features and enhancements in previous releases of the generic version of AnalyticsAI.
What's new - Data Analytics DA-10
AnalyticsAI
Envision
Envision provides a quick visualization of the transaction data that's been imported into an AnalyticsAI engagement.
Envision is divided into several widgets:
- Überblick
- Summary
- Distribution
- Posted Date Distribution
Refer to Envision for more information.
Notebooks
Notebooks are interactive documents that contain live code together with markdown text. Using Notebooks, you can build and explore custom analysis, and display the results. Each notebook consists of a series of cells. Run each cell individually in sequence to view its output or run the entire notebook.
Notebook files have the .ipynb file name extension and can be explored, modified and run in JupyterLab, an open-source notebook editor. The Data Analytics team has re-engineered out-of-the box Analytics AI tests to work with a new Notebooks engine. You can access these from the AnalyticsAI platform.
Notebooks are interactive documents that contain live code together with markdown text. Using Notebooks, you can build and explore custom analysis, and display the results. Each notebook consists of a series of cells. Run each cell individually in sequence to view its output or run the entire notebook.
Notebook files have the .ipynb file name extension and can be explored, modified and run in JupyterLab, an open-source notebook editor. You can access these from the AnalyticsAI platform.
To launch a notebook:
- Select a test in the Configuration page.
- Select Explore test. The notebook for the selected test displays.
Hinweis: The initial launch of a CWI Notebook in an engagement by each user may take several minutes. Changes made in notebooks, including those in the code cells as well as the markdown cells, are not saved.
Hinweis: The initial launch of a CWI Notebook in an engagement by each user may take several minutes. The Data Analytics team is working on reducing the initial load times. Changes made in notebooks, including those in the code cells as well as the markdown cells, are not saved.
Refer to Get started with AnalyticsAI Notebooks SDK for more information .
Data import
Import from online accounting software
Some minor UX improvements have been made in this release.
- The Next button now appears in the same place on each page of the wizard.
- The message on the final page of the wizard has been improved.
What's new - Data Analytics DA-9
AnalyticsAI
There are no updates to AnalyticsAI in this release.
Data import
Transaction file import
This release has added a new processing step to enable file validation during tagging.
Entry number error message
Now, when mapping a column in a transactions file to ENTRY NUMBER, LINE NUMBER or ENTRY ID, an error displays if any blank cells are detected.
Click on the warning to show the blank cells and their line numbers. With this information, you can correct the file using a tool of your choice, or contact your client with this information and ask for a corrected transactions file.
An error also displays if there are blank rows.
You will not be able to import files with errors -- the Import button on the Import Transactions page will be inactive.
Amount error message
When mapping a column in a transactions file to AMOUNT, an error displays if any non-numeric properties are present.
Click on the warning to view the affected data.
You will not be able to import files with errors -- the Import button on the Import Transactions page will be inactive.
Unassigned value warnings
When mapping a column in a transactions file to DOCUMENT TYPE, POSTING STATUS, IDENTIFIER TYPE or ORIGINATING DOCUMENT TYPE, a warning displays if there are any unassigned values. For example,
Duplicate entries
If duplicate transactions are detected in CSV files, either in the same file, or a subsequent file in an engagement, the duplicate transactions will be ignored on import.
Attempting to import duplicate transactions will no longer corrupt the transactions database. Additionally, if an import fails, users will be able to upload and import another file. Prior to this release this action would also result in a corrupted datbase.
Hinweis: Transaction duplicates are based on the entry number property, not the entire transaction.
What's new - Data Analytics DA-8
AnalyticsAI
This release includes the following bug fix:
- There was an inconsistency in the High Amounts test default percentile. The default percentile is now set to 99.1%.
Data import
Transaction import
SIZE and STATUS columns have been added to the Import Transactions page.
Import from online accounting software
With this release, the Transactions checkbox on the Configure Data page do not appear in products that don't support transaction imports.
More detailed error messages have been added to the STATUS column in the Summary: Import Status page. For example, when you import data with dates that are outside of the date set for the engagement, the message in the example below displays.
What's new - Data Analytics DA-7
AnalyticsAI
The graphical widget user interface for High Risk Exceptions was updated. High Risk Exceptions displays all tests with the pagination feature.
Users are now able to add tickmarks and annotations to a transaction.
Data import
There are no updates to Data Import for this release.
What's new - Data Analytics DA-6
AnalyticsAI
This release includes the following bug fixes:
- Redirects for AAI and CSV import links for AAI engagements created from subfolders on Collaborate.
- Failure to export files due to tagged and blank posting date.
- Configuration page does not work well with narrow viewports.
- Configuration page risk score should have an input limit.
- Not showing spinners on AnalyticsAI test LOADING status.
- MS service (AAI, CSV Import) link goes through constant loop when engagement is created from folder.
- Issues with AAI for tagged but blank posting date.
Data import
Major improvements have been made to how you import data into an engagement from online accounting platforms.
With this new functionality enabled, the Data page has been simplified to include a single button to access online accounting software.
When you select Online Accounting Software, the Import Transactions wizard displays:
These platforms will continue to be supported:
- Exact (NL and BE)
- SnelStart
- Visma - eAccounting
- Octopus (NL and BE)
- Yuki (NL and BE)
- Twinfield
- Quickbooks Online
- Xero
Additionally, we have added support for:
- Freshbooks
- Microsoft Dynamics 365: Business Central
Limitations for the initial release:
- Transactions import is limited to all transactions within the last five years to the import date.
- You will not be able to filter import providers by product.
What's new - Data Analytics AnalyticsAI 2020.4
AnalyticsAI
There are several changes to AnalyticsAI for this release.
Displayed currency
Currency symbols now show where currency amounts display in AnalyticsAI. Zum Beispiel:
Tipp: You can change the currency symbol for your product from the Cloud menu (
) under Customization | Regional Settings.
Version visible in footer
The version of AnalyticsAI now shows in the footer of the RESULTS and CONFIGURATION pages.
Faster data analysis
Improvements have been made to analysis time and performance for large transaction sets.
Direct export to engagement file
A Save to Engagement function has been added to the Export option in the RESULTS tab.
This dialog gives you the same files options as Download, with the added ability to save them to a specific folder in the engagement.
Data import changes
The ability to delete a saved data layout has been added to the SELECT DATA LAYOUT drop-down. A layout can only be deleted by the person who created it.
What's new - AnalyticsAI 2020.1
This highlights the major changes since the last release of this product.
AnalyticsAI changes
A number of improvements have been made in AnalyticsAI for this release.
Translations are now supported and implemented
You can now select AnalyticsAI's language from the Language drop-down in the top-right of the Caseware Cloud login screen. You must be logged out to do this.
When you log back in, you will see the following AnalyticsAI elements in the selected language:
- The login screen
- All elements on the Results page
- All elements on the Configuration page
- The Export Data Locally dialog
- The contents of the Analysis Summary PDF when exported
Improved export file name defaults
The default file name formats for exported data files have been improved.
| Exported file type | File name format |
| Analysis Summary PDF | <year>_<month>_<day>_<entity>_AAi Summary.pdf |
| Results (CSV) | <year>_<month>_<day>_<entity>_AAi Audit Evidence.csv |
| All Data (CSV) | <year>_<month>_<day>_<entity>_AAi All Data.csv |
For more information on exporting results, see Export AnalyticsAI results.
CSV export headers consistent
Header information for exported Results and All Data CSV files is now consistent.
Added approved_by property to Results CSV export
The CSV file that is created by a Results export from the Export Data Locally dialog now includes an approved_by column.
Data import changes
Improvements have been made to the process for importing trial balance CSV files.
Data layouts
This new functionality lets you save data layouts for transactions properties. This saves time by avoiding the need to map similar transactions files for multiple imports.
Now, you can map an imported transactions file in the usual manner, and then save the layout for future use.
See Import the client's transactions for more information.
What's new - AnalyticsAI 2019.8
This highlights the major changes since the last release of this product.
Configuration page improvements
When the dates in a data file don't match the engagement's dates, the Run tests on drop-down now appears on the Configuration page. You can run tests on:
- All data
- Current year
Additionally, the Save & Run Tests button is now called Run Tests.
Style Improvements to Tagging Dropdown
These improvements have been made to the Import as dialog that appears when you are mapping an imported .csv transactions file:
- The Select button has been removed. Now, simply click an available item in the list to select it.
- The arrows that appeared beside each potential selection have been removed.
- Unused properties that were visible during the transactions file mapping process have been hidden in this release.
What's new - AnalyticsAI 2019.7
This highlights the major changes since the last release of this product.
Updates to transactions import
The process for importing and mapping .csv transaction files has been improved for this release.
You can now import multiple transaction files. When you do this, the files are processed into a single data file for analysis.
The process for mapping imported transaction files has also been improved, including better descriptions for each data type.
See Import clients transactions for more information.
Improvements to data export
The data in the Analysis Summary PDF now includes:
- Time Series Graph – Risk-to-Value of Transactions
- List of Tests Performed
- List of Accounts Influenced
- Appendix A: Descriptions of Tests Performed
Status of tests
The Configuration page now shows test statuses as follows:
- An In progress indicator shows for any test that is running.
- Not run – grey status icon.
- Precondition failed – yellow status icon.
- Pending run – grey status icon.
- Failed run – red status icon.
- Successful run – green status icon.
What's new - AnalyticsAI 2019.6
This highlights the major changes since the last release of this product.
Outlier detection
These outlier detection tests have been added for this release:
- Angle-based Outlier Detection
- Cluster-based Local Outlier Factor
- Histogram-based Outlier Detection
- Isolation Forest Outliers
- K-Nearest Neighbours
- Local Outlier Factor
- Minimum Covariance Determinant
- Principal Component Analysis
See Outlier detection for more information.
Fiscal year filter
If you have data outside of the fiscal year of the audit, you now have the option to only test the transactions within the fiscal year.
In the following example, the engagement properties show a fiscal period of January 1, 2017 to December 31, 2017.
Because this engagement has data from more than just 2017, the following option appears on the Configuration page. Select the checkbox if you wish to run analyses on data solely from the period of the engagement.
Currency symbols removed
For easier Internationalisation, currency symbols have been removed from the Results page.
What's new - AnalyticsAI 2019.5
This article is intended to highlight the major changes since the beta release of this product. It is not a listing of all changes.
Improved workflow
When you open a new engagement in AnalyticsAI, the following workflow now appears on the Documents page:
See AnalyticsAI workflow for more information.
Improvements to trial balance and online transactions import
The following options are now available for importing data into AnalyticsAI:
See Upload trial balance in AnalyticsAI for more information.
Risk analysis configuration page
Tests on the Configuration page now include a pie chart that shows the percentage and quantity of the flagged transactions for that test. Pie charts appear when a test has flagged transactions. The pie chart shows the percentage of transactions flagged by that test.
Some tests, such as High Amounts include a pie chart and an additional graph that helps you configure parameters.
See AnalyticsAI configuration for more information.
Time series chart
A new widget has been added to the Results page.
Use the Time Series chart to observe the risk score and dollar value of evaluated transactions over time. Hover over a bar or line to further investigate by summing the value of transactions over a given risk threshold for a given month.
