audit team at work in front of computer

 

Arbutus - the best interface between
your data and meaningful answers.

Simplify your path to better
utilization and results.

Arbutus gives you powerful audit analytics that will
uncover results.

Commands Used to Perform Benchmark Tests

Here are the commands used to perform benchmark tests comparing Arbutus version 5.5 desktop and server products with the competitor’s latest version 10 desktop product. Where the commands differ, we’ve shown them as:

ARBUTUS COMMANDS IN BLACK

COMPETITOR’S V10 COMMANDS INDENTED IN BLUE

IN TESTS WHERE THE COMMANDS ARE IDENTICAL, THEY ARE ONLY SHOWN IN BLACK


Commands in Arbutus vs. Competitor’s V10 Desktop

IMPORT XML TO importxml RECORD_LENGTH 105 FIELDS Tp ASCII 1 1, Date DATETIME 2 10 PIC ‘mm/dd/yyyy’, Co PRINT 12 2 0, Br PRINT 14 2 0, Dp PRINT 16 2 0, GL PRINT 18 3 0, Batch PRINT 21 5 0, Amount PRINT 26 11 2, abs PRINT 37 10 2 END “smallxml.txt” “importxml.FIL” RECORDS 0>

IMPORT XML TO importxml “F:\Project\importxml.fil” FROM “smallxml.txt” FIELD “Tp” C AT 1 DEC 0 WID 1 PIC “” AS “” RULE “/RECORDS/RECORD/Tp/text()” FIELD “Date” D AT 2 DEC 0 WID 10 PIC “YYYY-MM-DD” AS “” RULE “/RECORDS/RECORD/Date/text()” FIELD “Co” C AT 12 DEC 0 WID 2 PIC “” AS “” RULE “/RECORDS/RECORD/Co/text()” FIELD “Br” C AT 14 DEC 0 WID 2 PIC “” AS “” RULE “/RECORDS/RECORD/Br/text()” FIELD “Dp” C AT 16 DEC 0 WID 2 PIC “” AS “” RULE “/RECORDS/RECORD/Dp/text()” FIELD “GL” N AT 18 DEC 0 WID 3 PIC “” AS “” RULE “/RECORDS/RECORD/GL/text()” FIELD “Batch” C AT 21 DEC 0 WID 5 PIC “” AS “” RULE “/RECORDS/RECORD/Batch/text()” FIELD “Amount” N AT 26 DEC 2 WID 11 PIC “” AS “” RULE “/RECORDS/RECORD/Amount/text()” FIELD “abs” N AT 37 DEC 2 WID 10 PIC “” AS “” RULE “/RECORDS/RECORD/abs/text()”

IMPORT DELIMITED TO importcsv RECORD_LENGTH 120 FIELDS Tp ASCII 1 1, Date ASCII 2 10, Co ASCII 12 2, Br ASCII 14 2, Dp ASCII 16 2, GL ASCII 18 3, Batch ASCII 21 5, Amount PRINT 26 11 2, abs PRINT 37 10 2 END “F:\Project\smallcsv.csv” 1 44 34

IMPORT DELIMITED TO importcsv “importcsv.fil” FROM “smallcsv.csv” 0 SEPARATOR “,” QUALIFIER ‘”‘ CONSECUTIVE STARTLINE 1 KEEPTITLE FIELD “Tp” C AT 1 DEC 0 WID 2 PIC “” AS “” FIELD “Date” C AT 3 DEC 0 WID 10 PIC “” AS “” FIELD “Co” C AT 13 DEC 0 WID 2 PIC “” AS “” FIELD “Br” C AT 15 DEC 0 WID 2 PIC “” AS “” FIELD “Dp” C AT 17 DEC 0 WID 2 PIC “” AS “” FIELD “GL” C AT 19 DEC 0 WID 3 PIC “” AS “” FIELD “Batch” C AT 22 DEC 0 WID 5 PIC “” AS “” FIELD “Amount” N AT 27 DEC 2 WID 11 PIC “” AS “” FIELD “abs” N AT 38 DEC 2 WID 10 PIC “” AS “”

IMPORT EXCEL TO excel_import FILE “data.xlsx” TABLE “`Import_Test` A” SERVER “LOCAL” SOURCE “Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)” FLAT “excel_import.fil” FIELDS A.”Type”,A.”Date1″,A.”Co”,A.”Br”,A.”Dp”,A.”GL”,A.”Batch”,A.”Amount”,A.”abs” END

IMPORT EXCEL TO excel_import “F:\Project\ excel_import.fil” FROM “data.xlsx” TABLE “Import_Test” KEEPTITLE FIELD “Type” C WID 1 AS “” FIELD “Date1” D WID 19 PIC “YYYY-MM-DD” AS “” FIELD “Co” C WID 2 AS “” FIELD “Br” C WID 2 AS “” FIELD “Dp” C WID 2 AS “” FIELD “GL” N WID 3 DEC 0 AS “” FIELD “Batch” N WID 5 DEC 0 AS “” FIELD “Amount” N WID 11 DEC 2 AS “” FIELD “abs” N WID 10 DEC 2 AS “”

EXPORT ALL XML TO “result”

EXPORT ALL DELIMITED TO “result” SEPARATOR “,” QUALIFIER ‘”‘

EXPORT ALL XLSX TO “result”

DUPLICATES ON city state addr NEAR 1 TO “result”

FUZZYDUP ON city+state+addr OTHER addr LEVDISTANCE 1 DIFFPCT 50 RESULTSIZE 50 TO “result”

DUPLICATES ON addr NEAR 1 TO “result”

FUZZYDUP ON addr OTHER addr LEVDISTANCE 1 DIFFPCT 50 RESULTSIZE 10 TO “result”

JOIN PKEY batch SKEY batch FIELDS batch amount WITH amount TO “result” PRESORT SECSORT

EXTRACT RECORD TO “result” IF datetime>=`20130603 080000` AND datetime <=`20130603 170000`

EXTRACT RECORD TO “result” IF amount>1000000

INDEX ON amount TO “result”

SORT ON batch TO “result

CLASSIFY ON Batch ACCUMULATE Amount

STRATIFY ON amount ACCUMULATE amount INTERVAL 20 MIN -9000000 MAX 9000000

SAMPLE ON Amount INTERVAL 1000000000 RECORD TO “result”

TOTAL amount

STATISTICS ON datetime NUMBER 5

STATISTICS ON amount NUMBER 5

SUMMARIZE ON Batch ACCUMULATE Amount OTHER GL PRESORT TO “result”